[thelist] putting MSSQL in single user mode - how long should it take?

Joel D Canfield joel at streamliine.com
Fri Mar 9 14:51:02 CST 2007

I'm connected remotely to a corrupt SQL server db; trying to put it in single user mode. ran the command

    alter database db_name set SINGLE_USER

(hopefully obviously, db_name is really the db name)

and it's been running for half an hour. it's not a big db.

any clues how long it should take?



No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date: 3/8/2007 10:58 AM

More information about the thelist mailing list