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 DATAB
ASE and use the ROLLBACK
option to kick out existing users.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"jelliott@.alexlee.com" <anonymous@.discussions.microsoft.com> wrote in messag
e
news:9c2801c3eb21$4a0f7140$a001280a@.phx.gbl...
quote:

> 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