Cannot Edit Object, which is in use by “Domain\Username” at Site “Site”

You can sometimes receive this error when the console crashes while you were in the middle of working on something.

To clear the lock, you need to remove it from the back end database.

1. Open up SQL Management Studio
2. Right click the SCCM Database and Click New Query
3. Execute the query Select * from SEDO_LockState
   
4. Search for the LockState, which can be located with the AssignedUser column and LockStateID = ‘1’
5. Note down the ID of that row (eg 16778622)
6. Execute the query delete from SEDO_LockState where ID=‘16778622’
   
7. You will receive a message saying (1 row(s) affected)
8. Check that row is removed by executing Select * from SEDO_LockState
9. You’re done!