Showing posts with label Kill Active transactions in sqlserver 2005. Show all posts
Showing posts with label Kill Active transactions in sqlserver 2005. Show all posts

Thursday, June 10, 2010

Kill active transaction in sqlserver

Killing active tractions:
Before we kill active transactions we need to check what are all the open transactions running in our data base.
steps:
1.Choose data base name
2.execute DBCC OPENTRAN()
3.It shows open transactions with SID
4.Note down SID value like 54..
5.Run KILL 54

Wait for a time then check it.