ShowTransactions

Table of Contents



Shows all transactions that are current active. Optionally specifying a process id.


round-pushpin Shows active transaction for all processes.
Exec ShowTransactions

round-pushpin Shows active transactions for the process id 1.
Exec ShowTransactions 1





SQL::ShowCachePages
Displays information about cached database pages.
SQL::ShowScalarFunctions
Displays the list of built-in scaler functions and their parameters.
SQL::ShowSystemFunctions
Displays the list of built-in system functions and their parameters.
SQL::System Procedures
Built in procedures that allow you to evaluate various aspect of the database engine.