SCCM 2012 R2 SP1 – Unlocking objects “in use”

Since moving to SCCM 2012 R2 SP1 at some sites, I’ve been having some issues where the console crashes while editing task sequences.

This is frequent, maybe once every 2 or 3 days… and is something that I’ve only been experiencing since SP1.

The downside of this, is that even when restarting the console or the entire server, the TS is locked for editing.

Fortunately – this article was unavailable on how to clear the lock

The short version

Open SQL manager
Create a new query against the CM database
select * from SEDO_LockState where LockStateID <> 0
DELETE from SEDO_LockState where LockID = ‘<LockID of the record identified in the previous query>’