ShowSchemaPolicy

Table of Contents

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.

ShowSchemaPolicy(String schemaName)

Schema, Permission, Rule, InheritedFromRole and InheritedFromSchema.

Shows the policy for a schema.

EXEC ShowSchemaPolicy('WordList:Word')

Returns unused cache memory to the operating system. Call ClearCacheAllocations first to release as much memory as possible.

Accounts, roles, memberships and schema permissions.

Lists the built-in aggregate functions with their parameters and descriptions.

Shows which process is blocking each blocked process, optionally for a single process.

Shows the tree of blocking processes, the processes they block and the resources being waited on. The tree is returned as a message.

Shows the health counters tracked by the engine, such as cache hits and misses and lock wait time.

Shows every lock held by every transaction, optionally for a single process.

Shows the operating system's view of the memory used by the database engine.

Shows the permissions that the logged in account has on a schema, and the role and schema each was inherited from.

Shows every connected process (session) with its session id, process id, client name and transaction state, optionally for a single process.