Perry Whittle (3/30/2012)
You shouldn't need to set the database single user first, just issue the following
alter database set offline with rollback immediate
[/Code]
That would accomplish setting it offline and kicking out all users in one step, but having the database in single-user mode when it is brought online again is useful as it gives us a chance to run some verification checks on the database after the data files have been moved, and before others begin to use it. We can change the database to single-user mode while the database is offline though.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato