I am trying to ALTER database from SINGLE user to MULTI-USER access level.

I am trying to ALTER database from SINGLE user to MULTI-USER access level.
using this command, and get the following error.  Please help.

ALTER DATABASE db SET MULTI_USER



ERROR Message:
-----------------------

bodyMsg 5064, Level 16, State 1, Line 1

Changes to the state or options of database 'niku' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

Allen2012Asked:
Who is Participating?
 
Scott PletcherSenior DBACommented:
Woah.

You have two choices:

1) Research which user is using the db (might turn out to be you, since SQL sometimes "remembers" past activity :-) ), figure out if it's vital, how to re-do whatever is being done, etc..

2) Forcibly set the db into multi_user mode, forcibly cancelling whatever the current user is doing:

ALTER DATABASE db SET MULTI_USER WITH ROLLBACK IMMEDIATE
0
 
Darius GhassemCommented:
Restart the SQL Services this will allow you to run the command
0
 
Allen2012Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.