Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to:
SQL Server
Azure SQL Managed Instance
Contains the set of SQL modules for server-level triggers of type TR. You can join this relation to sys.server_triggers. The tuple (object_id) is the key of the relation.
Column Name | Data Type | Description |
---|---|---|
object_id | int | This is a FOREIGN KEY reference back to the server-level trigger where this module is defined. |
definition | nvarchar(max) | SQL text that defines this module. NULL = Encrypted. |
uses_ansi_nulls | bit | Module was created with ANSI NULLS set option set to ON. |
uses_quoted_identifier | bit | Module was created with QUOTED IDENTIFIER set option set to ON. |
execute_as_principal_id | int | ID of the EXECUTE AS server principal. NULL by default or if EXECUTE AS CALLER ID of the specified principal if EXECUTE AS SELF EXECUTE AS principal-2 = EXECUTE AS OWNER. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.