Allen2012
asked on
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.
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.
Restart the SQL Services this will allow you to run the command
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks