August 6, 2013 at 9:50 am
Hi ,
I have database with single user mode
now changing to MULTI_USER
i used below script
ALTER DATABASE MC_DB SET MULTI_USER;
But i am getting below issue(restarted the SQL server also)
Msg 1205, Level 13, State 68, Line 1
Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
What can i do to change database single_user to multi_user?
August 6, 2013 at 10:13 am
Close any connections to the database and then connect and re run the query
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2013 at 10:18 am
Do you have any open transaction somewhere? In another window perhaps?
August 6, 2013 at 12:00 pm
ALTER DATABASE MC_DB SET MULTI_USER WITH ROLLBACK IMMEDIATE
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply