Tuesday, September 7, 2010

Killing open transaction in Sql server

In Sql server 2005 we can see open Tranasctions by using DBCC Command

DBCC opentran() Press enter

It Shows open transactions with Tranaction ID(Process ID)

Then Apply kill command

Kill 45 ( here 45 is pocessID)

1 comment: