| title | sys.server_triggers (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.server_triggers (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 06/10/2016 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server]
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 [!INCLUDEssNoVersion] component. |
| is_disabled | bit | 1 = Trigger is disabled. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.