Unlocking ConfigMgr Objects

here is what you need to do when you get the error blow in SCCM2012 console:
“Cannot edit the object, which is in use by ‘’ at Site ‘’.”

This happened as the result of the ConfigMgr console crashing while he had the object open.

To resolve this issue connect with sql management studio to the SQL server where the database is running and then execute the code below:

The query above will get you a list of possible locks on the dB, with the code below you can remove the lock:

Once the record is removed, you should be able to modify the object.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.