Need to change DB 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

SQL Server 2000 Forums

SQL Server Administration (2000)

Need to change DB mode

Author

Topic

btamulis
Yak Posting Veteran

64 Posts

Posted - 2010-12-22 : 11:04:28

My sql2000 db is showing as 'single user mode'.

I right click properties and get an error 'database is in single user mode can not connect.

I use the alter database script in query analyzer and I get a message single user cannot be changed someone is already connected.

No one is connected that I know of.

Is there another way? Start and stop service?

btamulis
Yak Posting Veteran

64 Posts

Posted - 2010-12-22 : 11:14:59

I got this fixed - I had to stop the service and re-start. After restarting I was able to change properties back to multi user mode.

Thanks