September 13, 2012

Find uncommitted Transactions in SQL Server

By using this command one can easily find uncommitted transactions in SQL server.


dbcc openTran()
Output will show :
SP ID

Transaction start Date and other details
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)