Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm unable to drop, delete or alter a database in my Local SQL Server instance.

I have run sp_Who2 and there don't appear to be any processes using the database apart from a process which gets spawned by my issuing the Alter Database command (I do this against the Master db). This process has a Wait type of LCK_M_X and a value of -2 for the Blocked By attribute.

I have issued KILL commands against them and I've restarted all the related system services and my machine a few times but to no avail. Is there anything else I can try?

share|improve this question
1  
-2 is an DTC transaction. What else is going on? And try this sqlserverclub.com/articles/… –  gbn Dec 12 '11 at 12:44
    
Thanks for your response. Please see the screenshot here: largedocument.com/4/ec24da47/dbLockIssue.PNG - I can't see anything too suspicious apart from the one above. –  5arx Dec 12 '11 at 12:55
add comment

1 Answer 1

up vote 1 down vote accepted

Stop (do your alter) and start DTC and all will be fine.

share|improve this answer
    
Worked for me! Many thanks :-) –  5arx Dec 13 '11 at 10:12
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.