Posted by Mike on 12/20/07 11:46

I'm having trouble running TSQL commands when SQL2005 is in single-
user mode.

I've restarted SQL with -m, -c, -T3608 set in the startup options.

I can get into Config manager OK, but as soon as I try to start a New
Query it complains that the DB is in single-user mode and there's
already someone connected to the DB.

Is there something I need to turn off? If not, how am I supposed to
run queries in single-user mode? What I want to do is move the model
and msdb databases but I can't run the commands to do this until I get
past this problem.

Thanks for any assistance you can give on this.

Mike

• Next in forum: Imitating ownership possible?
• Prev in forum: Loose ODBC conection
• Thread view: SQL2005: Running TSQL commands in single-user mode

[Reply to this message]