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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy