ShowTransactions

Table of Contents



Shows every active transaction, optionally for a single process.

ShowTransactions(Numeric processId = null)

Permissions

Requires an account that is a member of an administrator role.


Process Id, Blocked?, Blocked By, References, Start Time, Held Lock Keys, Granted Locks, Cached for Read, Deferred IOs, Active?, Deadlocked?, Cancelled? and User Created?

round-pushpin Shows all transactions.
EXEC ShowTransactions

round-pushpin Shows the transaction of process 1.
EXEC ShowTransactions(1)




SQL :: Transaction
Transactions make a group of statements all-or-nothing.