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:
select * from SEDO_LockState where LockStateID <> 0
The query above will get you a list of possible locks on the dB, with the code below you can remove the lock:
DELETE from SEDO_LockState where LockID = ‘<LockID of the record identified in the previous query>’
Once the record is removed, you should be able to modify the object.