alter

ALTER DATABASE <bd> SET SINGLE_USER with rollback immediate
and then
ALTER DATABASE <bd> Set MULTI_USERGot it, thanks.
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:E1D27BFF-57E1-4DEC-8D29-D9DF90A799DD@.microsoft.com...
> ALTER DATABASE <bd> SET SINGLE_USER with rollback immediate
> and then
> ALTER DATABASE <bd> Set MULTI_USER
>