How to solve SQL Server Error 1222 i.e Unlock a SQL Server table
In the SQL Server Management Studio,to find out details of the active transaction, execute following command
DBCC opentran()You will get the detail of the active transaction, then from the SPID of the active transaction, get the detail about the SPID using following commands
exec sp_who2 <SPID>exec sp_lock <SPID>For example, if SPID is 69 then execute the command as
exec sp_who2 69exec sp_lock 69Now , you can kill that process using the following command
KILL 69I hope this helps :)
It's been a while, but last time I had something similar:
ROLLBACK TRANor trying to
COMMITwhat had allready been done free'd everything up so I was able to clear things out and start again.
To prevent this, make sure every BEGIN TRANSACTION has COMMIT
The following will say successful but will leave uncommitted transactions:
BEGIN TRANSACTIONBEGIN TRANSACTION<SQL_CODE?COMMITClosing query windows with uncommitted transactions will prompt you to commit your transactions. This will generally resolve the Error 1222 message.