Help - Single user mode enabled

[pglover]

Can anyone advise how to change a db from single user mode?

A (*&^%$) user has enabled signle user mode and effectively locked us (2nd line) out.

The security logins are

windows\adminstrators - dbo
sa - sys-adm

sa cannot access the db to turn off single user mode.

Any ideas please?

Thanks

PJ

 

[JamesLean]

If it's just the database that is single-user then try issuing the following command:

ALTER DATABASE database SET MULTI_USER

--James

 

[pglover]

Hi James

It won't allow me to - in case I didn't supply info correctly I have pasted the QA error below -

Server: Msg 5064, Level 16, State 1, Line 1
Changes to the state or options of database 'epms' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
Server: Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

 

[JamesLean]

in that case, you will need to find out who is connected to the DB and get them to disconnect, so you can connect and change the mode.

Use the current activity window in Ent Mgr to see who is currently connected to the DB.

--James

 

[pglover]

James

You're a star!

Thanks

PJ