Tuesday, February 21, 2012

restore

hello all
How do I get exclusive rights to the db. I tried to set it to offline but
the db refused to let me while users are connected.
Please advise
Regards
AndreAndre,
Check out the WITH ROLLBACK IMMEDIATE and ROLLBACK AFTER arguments of the
ALTER DATABASE statement.
HTH
Jerry
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:708D1B6B-73C6-4D69-8405-5BD35DCC20F5@.microsoft.com...
> hello all
> How do I get exclusive rights to the db. I tried to set it to offline but
> the db refused to let me while users are connected.
> Please advise
> Regards
> Andre

No comments:

Post a Comment