sys.server_triggers (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Managed Instance
Contains the set of all server-level DDL triggers with object_type of TR or TA. In the case of CLR triggers, the assembly must be loaded into the master database. All server-level DDL trigger names exist in a single, global scope.
| Column Name | Data Type | Description |
|---|---|---|
| name | sysname | Name of the trigger. |
| object_id | int | ID of the object. |
| parent_class | tinyint | Class of parent. Is always: 100 = Server |
| parent_class_desc | nvarchar(60) | Description of class of parent. Is always: SERVER. |
| parent_id | int | Always 0 for triggers on the SERVER. |
| type | char(2) | Object type: TA = Assembly (CLR) trigger TR = SQL trigger |
| type_desc | nvarchar(60) | Description of the class of the object type. CLR_TRIGGER SQL_TRIGGER |
| create_date | datetime | Date the trigger was created. |
| modify_date | datetime | Date the trigger was last modified by using an ALTER statement. |
| is_ms_shipped | bit | Trigger created on behalf of the user by an internal SQL Server component. |
| is_disabled | bit | 1 = Trigger is disabled. |
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.
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for