Kill un-commit transaction on SQL Server

When developer use SQL Server to create any transaction, sometimes they forget to rollback the transaction with begin transaction statement. It will cause the Timeout for the database as the transaction is still remain open.

The following steps will help you to solve the problem.

Check if any open transaction here: DBCC OPENTRAN

Kill the UId which is open if any with: KILL 80

Posted by justinpham

Leave a Reply