Fixing Open Transaction Blocks in SQL 2005

by fwhagen Wed, 13 July 2011

Sometimes, when developing in SQL, a transaction will be left open.  Performance will fall through the floor, which can sometimes be the first sign that it happened.  If you cannot close the transaction properly, the following command will show the oldest, and probably orphaned, on the server:

DBCC OPENTRAN

The transaction can easily be termed by issuing a kill on the PID:

KILL 52

That should do it. 

Keywords: ,

Filed Under: Programming | SQL

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

TextBox

RecentPosts