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
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για