Wednesday, July 31, 2013

Error: the database could not be exclusively locked to perform the operation in sql server 2008 ?

as mentioned earlier by both these users just wait for all the connections to go and then try- it will succed


or else if it is dev\Uat environment & you can kill the conenctions - make the changes (use this as last option)


i was just wondering if you are connected to the same DB? If yes change your context to master(means connect to master DB ) and then issue this command.




Sarabpreet Singh Anand


Blog , Personal website


This posting is provided , "AS IS" with no warranties, and confers no rights.


Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.


No comments:

Post a Comment