Tuesday, 21 July 2015

how to Find and remove uncommitted or open transactions in SQL !


Write  DBCC OPENTRAN in the query window and execute

If open  transaction's available   Result will be 


Then

KILL server process ID
Example:  KILL 53 


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)