ManoharV
SSCommitted
Points: 1730
More actions
March 18, 2009 at 5:48 am
#135672
Can anybody help me to identify identify uncommitted transactions
in sql server and also terminating them.
Regards,
Manohar V
SQL_DBA_3
SSCarpal Tunnel
Points: 4772
March 18, 2009 at 6:01 am
#961742
DBCC OPENTRAN
with the SPID s you get from this terminate them using
KILL [i]spid[/i]
March 18, 2009 at 7:50 am
#961883
It worked....Thanks a lot.. :hehe:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply