Joshua Perry (3/21/2008)
Also, setting trace flag 3608 at startup and running in single user mode are the same thing, so two of the answers are identical.
Not entirely true. Trace flag 3608 prevents SQL Server from recovering any database except the master database. Single user mode is exactly that, only one connection allowed.