| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.server_triggers (Transact-SQL) |
sys.server_triggers (Transact-SQL) |
rwestMSFT |
randolphwest |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!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.