multi user mode - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

multi user mode

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-02-07 : 23:34:58

Dear All,
i've altered my database to single user mode. and now trying to change to multi user mode with the query
alter database mydb set multi_user
but it is saying that it is in single user mode. query analyser closed.
how can i change that to multi user mode? idont know who opend that
to run sp_who it is not showing the database in dropdown list in enterprise manager.

thanks in advance

Vinod
Even you learn 1%, Learn it with 100% confidence.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-08 : 01:34:18

Use sp_who2 to find out if anyone connect to the db already. Kill the process then change mode again.

CShaw
Yak Posting Veteran

65 Posts

Posted - 2008-02-08 : 01:34:34

have you re-started the system?

Chris Shaw
www.SQLonCall.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources