Exec

Table of Contents



EXEC (or EXECUTE) runs one of the built-in System Procedures. Parameters are passed in parentheses; the parentheses can be omitted when there are no parameters. Procedure names are not case-sensitive.

User-defined procedures

User-defined stored procedures are not currently available, see Alter Procedure. EXEC with a name that is not a system procedure fails with "Procedure not found".


round-pushpin Runs a procedure without parameters.
EXEC ShowProcesses

round-pushpin Runs a procedure with a parameter.
EXEC ShowLocks(1)




SQL :: ShowAggregateFunctions
Lists the built-in aggregate functions with their parameters and descriptions.
SQL :: ShowBlocks
Shows which process is blocking each blocked process, optionally for a single process.
SQL :: ShowBlockTree
Shows the tree of blocking processes, the processes they block and the resources being waited on. The tree is returned as a message.
SQL :: ShowHealthCounters
Shows the health counters tracked by the engine, such as cache hits and misses and lock wait time.
SQL :: ShowLocks
Shows every lock held by every transaction, optionally for a single process.
SQL :: ShowMemoryUtilization
Shows the operating system's view of the memory used by the database engine.
SQL :: ShowMySchemaPolicy
Shows the permissions that the logged in account has on a schema, and the role and schema each was inherited from.
SQL :: ShowProcesses
Shows every connected process (session) with its session id, process id, client name and transaction state, optionally for a single process.
SQL :: ShowScalarFunctions
Lists the built-in scalar functions with their parameters and descriptions.
SQL :: ShowSchemaPolicy
Shows the security policy that applies to a schema: each permission, whether it is granted or denied, and the role and schema it was inherited from.