Monday, March 26, 2012

lock out users and shrink database

I need a script or way to lock out users from a database
long enough to shrink/trucated the database....You can set the database to single user or restricted user using ALTER DATABASE and use the ROLLBACK
option to kick out existing users.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"jelliott@.alexlee.com" <anonymous@.discussions.microsoft.com> wrote in message
news:9c2801c3eb21$4a0f7140$a001280a@.phx.gbl...
> I need a script or way to lock out users from a database
> long enough to shrink/trucated the database....

No comments:

Post a Comment