RefreshMyRoles
Reloads the role memberships of the logged in account. Roles are cached at login, so run this after your memberships change instead of logging out and back in. The roles are returned as messages.
RefreshMyRoles()
EXEC RefreshMyRoles()SQL :: Security Policy
Accounts, roles, memberships and schema permissions.
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.