Wednesday, March 28, 2012

Putting a DB into Single User Mode...

How do I do this when that option is grayed out? Also,
how does the single vs. the other mode impact persons
using the db?
Thanks in advancePatrick,
You can also use the command:
ALTER DATABASE databasename SINGLE_USER
Why is the option grayed out? Do you have sufficient rights to issue the
command on this database? You must be the db_owner or in the system roles
of sysadmin or dbcreator.
Russell Fields
"Patrick Ross" <yourmcse@.msn.com> wrote in message
news:1274901c3f62b$c9afe3c0$a601280a@.phx
.gbl...
> How do I do this when that option is grayed out? Also,
> how does the single vs. the other mode impact persons
> using the db?
> Thanks in advance

No comments:

Post a Comment