gruppi di eventi DDLDDL Event Groups

QUESTO ARGOMENTO SI APPLICA A:sìSQL Server (a partire dalla versione 2008)sìDatabase SQL di AzurenoAzure SQL Data Warehouse noParallel Data Warehouse THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Nelle tabelle seguenti vengono elencati i gruppi di eventi DLL che è possibile utilizzare per eseguire un trigger DDL o una notifica degli eventi e vengono indicate le istruzioni Transact-SQLTransact-SQL incluse.The following tables list the DDL event groups that can be used to run a DDL trigger or an event notification, and also the Transact-SQLTransact-SQL statements they cover. Si noti la natura inclusiva dei gruppi di eventi.Note the inclusive nature of the event groups. Ad esempio, un trigger DDL o una notifica degli eventi che specifica FOR DDL_TABLE_EVENTS (10018) include le istruzioni Transact-SQLTransact-SQL CREATE TABLE, ALTER TABLE e DROP TABLE.For example, a DDL trigger or event notification that specifies FOR DDL_TABLE_EVENTS (10018) covers the CREATE TABLE, ALTER TABLE and DROP TABLE Transact-SQLTransact-SQL statements. In un trigger DDL o una notifica degli eventi che consente di specificare FOR DDL_TABLE_VIEW_EVENTS (type 10017) sono incluse tutte le istruzioni Transact-SQLTransact-SQL nei tipi DDL_TABLE_EVENTS, DDL_VIEW_EVENTS, DDL_INDEX_EVENTS e DDL_STATISTICS_EVENTS.A DDL trigger or event notification that specifies FOR DDL_TABLE_VIEW_EVENTS (10017) covers all Transact-SQLTransact-SQL statements under the types DDL_TABLE_EVENTS, DDL_VIEW_EVENTS, DDL_INDEX_EVENTS, and DDL_STATISTICS_EVENTS.

Nota

Alcune stored procedure di sistema che eseguono operazioni di tipo DDL possono inoltre attivare trigger DDL o notifiche degli eventi.Certain system stored procedures that perform DDL-like operations can also fire DDL triggers or event notifications. Testare i trigger DDL e le notifiche degli eventi per determinarne la risposta alle stored procedure di sistema eseguite.Test your DDL triggers and event notifications to determine their responses to system stored procedures that are run. Ad esempio, l'istruzione CREATE TYPE e la stored procedure sp_addtype consentono entrambe di attivare un trigger DDL o una notifica degli eventi creata in un evento CREATE_TYPE.For example, the CREATE TYPE statement and sp_addtype stored procedure will both fire a DDL trigger or event notification that is created on a CREATE_TYPE event.

EventiEvents

Gli eventi elencati in DDL_DATABASE_LEVEL_EVENTS vengono eseguiti a livello di server (istanza) o di database.The events listed under DDL_DATABASE_LEVEL_EVENTS execute at the server (instance) or database level. Gli eventi elencati in DDL_SERVER_LEVEL_EVENTS vengono eseguiti solo a livello di server.Events listed under DDL_SERVER_LEVEL_EVENTS execute only at the server level.

parent_typeparent_type Tipotype NAMEname
NULLNULL 296296 ALTER_SERVER_CONFIGURATIONALTER_SERVER_CONFIGURATION
NULLNULL 1000110001 DDL_EVENTSDDL_EVENTS
1000110001 1001610016 DDL_DATABASE_LEVEL_EVENTSDDL_DATABASE_LEVEL_EVENTS
1001610016 1002710027 DDL_ASSEMBLY_EVENTSDDL_ASSEMBLY_EVENTS
1002710027 102102 ALTER_ASSEMBLYALTER_ASSEMBLY
1002710027 101101 CREATE_ASSEMBLYCREATE_ASSEMBLY
1002710027 103103 DROP_ASSEMBLYDROP_ASSEMBLY
1001610016 1002910029 DDL_DATABASE_SECURITY_EVENTSDDL_DATABASE_SECURITY_EVENTS
1002910029 1003310033 DDL_APPLICATION_ROLE_EVENTSDDL_APPLICATION_ROLE_EVENTS
1003310033 138138 ALTER_APPLICATION_ROLEALTER_APPLICATION_ROLE
1003310033 137137 CREATE_APPLICATION_ROLECREATE_APPLICATION_ROLE
1003310033 139139 DROP_APPLICATION_ROLEDROP_APPLICATION_ROLE
1002910029 1003810038 DDL_ASYMMETRIC_KEY_EVENTSDDL_ASYMMETRIC_KEY_EVENTS
1003810038 248248 ALTER_ASYMMETRIC_KEYALTER_ASYMMETRIC_KEY
1003810038 247247 CREATE_ASYMMETRIC_KEYCREATE_ASYMMETRIC_KEY
1003810038 249249 DROP_ASYMMETRIC_KEYDROP_ASYMMETRIC_KEY
1002910029 1003610036 DDL_AUTHORIZATION_DATABASE_EVENTSDDL_AUTHORIZATION_DATABASE_EVENTS
1003610036 205205 ALTER_AUTHORIZATION_DATABASEALTER_AUTHORIZATION_DATABASE
1002910029 1003010030 DDL_CERTIFICATE_EVENTSDDL_CERTIFICATE_EVENTS
1003010030 198198 ALTER_CERTIFICATEALTER_CERTIFICATE
1003010030 197197 CREATE_CERTIFICATECREATE_CERTIFICATE
1003010030 199199 DROP_CERTIFICATEDROP_CERTIFICATE
1002910029 1003910039 DDL_CRYPTO_SIGNATURE_EVENTSDDL_CRYPTO_SIGNATURE_EVENTS
1003910039 257257 ADD_SIGNATUREADD_SIGNATURE
1003910039 255255 ADD_SIGNATURE_SCHEMA_OBJECTADD_SIGNATURE_SCHEMA_OBJECT
1003910039 258258 DROP_SIGNATUREDROP_SIGNATURE
1003910039 256256 DROP_SIGNATURE_SCHEMA_OBJECTDROP_SIGNATURE_SCHEMA_OBJECT
1002910029 1006610066 DDL_DATABASE_AUDIT_SPECIFICATION_EVENTSDDL_DATABASE_AUDIT_SPECIFICATION_EVENTS
1006610066 291291 ALTER_DATABASE_AUDIT_SPECIFICATIONALTER_DATABASE_AUDIT_SPECIFICATION
1006610066 290290 CREATE_DATABASE_AUDIT_SPECIFICATIONCREATE_DATABASE_AUDIT_SPECIFICATION
1006610066 292292 DROP_DATABASE_AUDIT_SPECIFICATIONDROP_DATABASE_AUDIT_SPECIFICATION
1002910029 1006210062 DDL_DATABASE_ENCRYPTION_KEY_EVENTSDDL_DATABASE_ENCRYPTION_KEY_EVENTS
1006210062 279279 ALTER_DATABASE_ENCRYPTION_KEYALTER_DATABASE_ENCRYPTION_KEY
1006210062 278278 CREATE_DATABASE_ENCRYPTION_KEYCREATE_DATABASE_ENCRYPTION_KEY
1006210062 280280 DROP_DATABASE_ENCRYPTION_KEYDROP_DATABASE_ENCRYPTION_KEY
1002910029 1003510035 DDL_GDR_DATABASE_EVENTSDDL_GDR_DATABASE_EVENTS
1003510035 171171 DENY_DATABASEDENY_DATABASE
1003510035 170170 GRANT_DATABASEGRANT_DATABASE
1003510035 172172 REVOKE_DATABASEREVOKE_DATABASE
1002910029 1004010040 DDL_MASTER_KEY_EVENTSDDL_MASTER_KEY_EVENTS
1004010040 253253 ALTER_MASTER_KEYALTER_MASTER_KEY
1004010040 252252 CREATE_MASTER_KEYCREATE_MASTER_KEY
1004010040 254254 DROP_MASTER_KEYDROP_MASTER_KEY
1002910029 1003210032 DDL_ROLE_EVENTSDDL_ROLE_EVENTS
1003210032 207207 ADD_ROLE_MEMBERADD_ROLE_MEMBER
1003210032 135135 ALTER_ROLEALTER_ROLE
1003210032 134134 CREATE_ROLECREATE_ROLE
1003210032 136136 DROP_ROLEDROP_ROLE
1003210032 208208 DROP_ROLE_MEMBERDROP_ROLE_MEMBER
1002910029 1003410034 DDL_SCHEMA_EVENTSDDL_SCHEMA_EVENTS
1003410034 142142 ALTER_SCHEMAALTER_SCHEMA
1003410034 141141 CREATE_SCHEMACREATE_SCHEMA
1003410034 143143 DROP_SCHEMADROP_SCHEMA
1002910029 1003710037 DDL_SYMMETRIC_KEY_EVENTSDDL_SYMMETRIC_KEY_EVENTS
1003710037 245245 ALTER_SYMMETRIC_KEYALTER_SYMMETRIC_KEY
1003710037 244244 CREATE_SYMMETRIC_KEYCREATE_SYMMETRIC_KEY
1003710037 246246 DROP_SYMMETRIC_KEYDROP_SYMMETRIC_KEY
1002910029 1003110031 DDL_USER_EVENTSDDL_USER_EVENTS
1003110031 132132 ALTER_USERALTER_USER
1003110031 131131 CREATE_USERCREATE_USER
1003110031 133133 DROP_USERDROP_USER
1001610016 1005210052 DDL_DEFAULT_EVENTSDDL_DEFAULT_EVENTS
1005210052 218218 BIND_DEFAULTBIND_DEFAULT
1005210052 220220 CREATE_DEFAULTCREATE_DEFAULT
1005210052 231231 DROP_DEFAULTDROP_DEFAULT
1005210052 242242 UNBIND_DEFAULTUNBIND_DEFAULT
1001610016 1002610026 DDL_EVENT_NOTIFICATION_EVENTSDDL_EVENT_NOTIFICATION_EVENTS
1002610026 7474 CREATE_EVENT_NOTIFICATIONCREATE_EVENT_NOTIFICATION
1002610026 7676 DROP_EVENT_NOTIFICATIONDROP_EVENT_NOTIFICATION
1001610016 1005310053 DDL_EXTENDED_PROPERTY_EVENTSDDL_EXTENDED_PROPERTY_EVENTS
1005310053 211211 ALTER_EXTENDED_PROPERTYALTER_EXTENDED_PROPERTY
1005310053 222222 CREATE_EXTENDED_PROPERTYCREATE_EXTENDED_PROPERTY
1005310053 233233 DROP_EXTENDED_PROPERTYDROP_EXTENDED_PROPERTY
1001610016 1005410054 DDL_FULLTEXT_CATALOG_EVENTSDDL_FULLTEXT_CATALOG_EVENTS
1005410054 212212 ALTER_FULLTEXT_CATALOGALTER_FULLTEXT_CATALOG
1005410054 223223 CREATE_FULLTEXT_CATALOGCREATE_FULLTEXT_CATALOG
1005410054 234234 DROP_FULLTEXT_CATALOGDROP_FULLTEXT_CATALOG
1001610016 1006710067 DDL_FULLTEXT_STOPLIST_EVENTSDDL_FULLTEXT_STOPLIST_EVENTS
1006710067 294294 ALTER_FULLTEXT_STOPLISTALTER_FULLTEXT_STOPLIST
1006710067 293293 CREATE_FULLTEXT_STOPLISTCREATE_FULLTEXT_STOPLIST
1006710067 295295 DROP_FULLTEXT_STOPLISTDROP_FULLTEXT_STOPLIST
1001610016 1002310023 DDL_FUNCTION_EVENTSDDL_FUNCTION_EVENTS
1002310023 6262 ALTER_FUNCTIONALTER_FUNCTION
1002310023 6161 CREATE_FUNCTIONCREATE_FUNCTION
1002310023 6363 DROP_FUNCTIONDROP_FUNCTION
1001610016 1004910049 DDL_PARTITION_EVENTSDDL_PARTITION_EVENTS
1004910049 1005010050 DDL_PARTITION_FUNCTION_EVENTSDDL_PARTITION_FUNCTION_EVENTS
1005010050 192192 ALTER_PARTITION_FUNCTIONALTER_PARTITION_FUNCTION
1005010050 191191 CREATE_PARTITION_FUNCTIONCREATE_PARTITION_FUNCTION
1005010050 193193 DROP_PARTITION_FUNCTIONDROP_PARTITION_FUNCTION
1004910049 1005110051 DDL_PARTITION_SCHEME_EVENTSDDL_PARTITION_SCHEME_EVENTS
1005110051 195195 ALTER_PARTITION_SCHEMEALTER_PARTITION_SCHEME
1005110051 194194 CREATE_PARTITION_SCHEMECREATE_PARTITION_SCHEME
1005110051 196196 DROP_PARTITION_SCHEMEDROP_PARTITION_SCHEME
1001610016 1005510055 DDL_PLAN_GUIDE_EVENTSDDL_PLAN_GUIDE_EVENTS
1005510055 216216 ALTER_PLAN_GUIDEALTER_PLAN_GUIDE
1005510055 228228 CREATE_PLAN_GUIDECREATE_PLAN_GUIDE
1005510055 238238 DROP_PLAN_GUIDEDROP_PLAN_GUIDE
1001610016 1002410024 DDL_PROCEDURE_EVENTSDDL_PROCEDURE_EVENTS
1002410024 5252 ALTER_PROCEDUREALTER_PROCEDURE
1002410024 5151 CREATE_PROCEDURECREATE_PROCEDURE
1002410024 5353 DROP_PROCEDUREDROP_PROCEDURE
1001610016 1005610056 DDL_RULE_EVENTSDDL_RULE_EVENTS
1005610056 219219 BIND_RULEBIND_RULE
1005610056 229229 CREATE_RULECREATE_RULE
1005610056 239239 DROP_RULEDROP_RULE
1005610056 243243 UNBIND_RULEUNBIND_RULE
1001610016 1006910069 DDL_SEARCH_PROPERTY_LIST_EVENTSDDL_SEARCH_PROPERTY_LIST_EVENTS
1006910069 298298 ALTER_SEARCH_PROPERTY_LISTALTER_SEARCH_PROPERTY_LIST
1006910069 297297 CREATE_SEARCH_PROPERTY_LISTCREATE_SEARCH_PROPERTY_LIST
1006910069 299299 DROP_SEARCH_PROPERTY_LISTDROP_SEARCH_PROPERTY_LIST
1001610016 1007010070 DDL_SEQUENCE_EVENTSDDL_SEQUENCE_EVENTS
1007010070 304304 ALTER_SEQUENCEALTER_SEQUENCE
1007010070 303303 CREATE_SEQUENCECREATE_SEQUENCE
1007010070 305305 DROP_SEQUENCEDROP_SEQUENCE
1001610016 1004110041 DDL_SSB_EVENTSDDL_SSB_EVENTS
1004110041 1006310063 DDL_BROKER_PRIORITY_EVENTSDDL_BROKER_PRIORITY_EVENTS
1006310063 282282 ALTER_BROKER_PRIORITYALTER_BROKER_PRIORITY
1006310063 281281 CREATE_BROKER_PRIORITYCREATE_BROKER_PRIORITY
1006310063 283283 DROP_BROKER_PRIORITYDROP_BROKER_PRIORITY
1004110041 1004310043 DDL_CONTRACT_EVENTSDDL_CONTRACT_EVENTS
1004310043 154154 CREATE_CONTRACTCREATE_CONTRACT
1004310043 156156 DROP_CONTRACTDROP_CONTRACT
1004110041 1004210042 DDL_MESSAGE_TYPE_EVENTSDDL_MESSAGE_TYPE_EVENTS
1004210042 152152 ALTER_MESSAGE_TYPEALTER_MESSAGE_TYPE
1004210042 151151 CREATE_MESSAGE_TYPECREATE_MESSAGE_TYPE
1004210042 153153 DROP_MESSAGE_TYPEDROP_MESSAGE_TYPE
1004110041 1004410044 DDL_QUEUE_EVENTSDDL_QUEUE_EVENTS
1004410044 158158 ALTER_QUEUEALTER_QUEUE
1004410044 157157 CREATE_QUEUECREATE_QUEUE
1004410044 159159 DROP_QUEUEDROP_QUEUE
1004110041 1004710047 DDL_REMOTE_SERVICE_BINDING_EVENTSDDL_REMOTE_SERVICE_BINDING_EVENTS
1004710047 175175 ALTER_REMOTE_SERVICE_BINDINGALTER_REMOTE_SERVICE_BINDING
1004710047 174174 CREATE_REMOTE_SERVICE_BINDINGCREATE_REMOTE_SERVICE_BINDING
1004710047 176176 DROP_REMOTE_SERVICE_BINDINGDROP_REMOTE_SERVICE_BINDING
1004110041 1004610046 DDL_ROUTE_EVENTSDDL_ROUTE_EVENTS
1004610046 165165 ALTER_ROUTEALTER_ROUTE
1004610046 164164 CREATE_ROUTECREATE_ROUTE
1004610046 166166 DROP_ROUTEDROP_ROUTE
1004110041 1004510045 DDL_SERVICE_EVENTSDDL_SERVICE_EVENTS
1004510045 162162 ALTER_SERVICEALTER_SERVICE
1004510045 161161 CREATE_SERVICECREATE_SERVICE
1004510045 163163 DROP_SERVICEDROP_SERVICE
1001610016 1002210022 DDL_SYNONYM_EVENTSDDL_SYNONYM_EVENTS
1002210022 3434 CREATE_SYNONYMCREATE_SYNONYM
1002210022 3636 DROP_SYNONYMDROP_SYNONYM
1001610016 1001710017 DDL_TABLE_VIEW_EVENTSDDL_TABLE_VIEW_EVENTS
1001710017 1002010020 DDL_INDEX_EVENTSDDL_INDEX_EVENTS
1002010020 213213 ALTER_FULLTEXT_INDEXALTER_FULLTEXT_INDEX
1002010020 2525 ALTER_INDEXALTER_INDEX
1002010020 224224 CREATE_FULLTEXT_INDEXCREATE_FULLTEXT_INDEX
1002010020 2424 CREATE_INDEXCREATE_INDEX
1002010020 274274 CREATE_SPATIAL_INDEXCREATE_SPATIAL_INDEX
1002010020 206206 CREATE_XML_INDEXCREATE_XML_INDEX
1002010020 235235 DROP_FULLTEXT_INDEXDROP_FULLTEXT_INDEX
1002010020 2626 DROP_INDEXDROP_INDEX
1001710017 1002110021 DDL_STATISTICS_EVENTSDDL_STATISTICS_EVENTS
1002110021 2727 CREATE_STATISTICSCREATE_STATISTICS
1002110021 2929 DROP_STATISTICSDROP_STATISTICS
1002110021 2828 UPDATE_STATISTICSUPDATE_STATISTICS
1001710017 1001810018 DDL_TABLE_EVENTSDDL_TABLE_EVENTS
1001810018 2222 ALTER_TABLEALTER_TABLE
1001810018 2121 CREATE_TABLECREATE_TABLE
1001810018 2323 DROP_TABLEDROP_TABLE
1001710017 1001910019 DDL_VIEW_EVENTSDDL_VIEW_EVENTS
1001910019 4242 ALTER_VIEWALTER_VIEW
1001910019 4141 CREATE_VIEWCREATE_VIEW
1001910019 4343 DROP_VIEWDROP_VIEW
1001610016 1002510025 DDL_TRIGGER_EVENTSDDL_TRIGGER_EVENTS
1002510025 7272 ALTER_TRIGGERALTER_TRIGGER
1002510025 7171 CREATE_TRIGGERCREATE_TRIGGER
1002510025 7373 DROP_TRIGGERDROP_TRIGGER
1001610016 1002810028 DDL_TYPE_EVENTSDDL_TYPE_EVENTS
1002810028 9191 CREATE_TYPECREATE_TYPE
1002810028 9393 DROP_TYPEDROP_TYPE
1001610016 1004810048 DDL_XML_SCHEMA_COLLECTION_EVENTSDDL_XML_SCHEMA_COLLECTION_EVENTS
1004810048 178178 ALTER_XML_SCHEMA_COLLECTIONALTER_XML_SCHEMA_COLLECTION
1004810048 177177 CREATE_XML_SCHEMA_COLLECTIONCREATE_XML_SCHEMA_COLLECTION
1004810048 179179 DROP_XML_SCHEMA_COLLECTIONDROP_XML_SCHEMA_COLLECTION
1001610016 241241 RENAMERENAME
1000110001 1000210002 DDL_SERVER_LEVEL_EVENTSDDL_SERVER_LEVEL_EVENTS
1000210002 214214 ALTER_INSTANCEALTER_INSTANCE
1000210002 1007110071 DDL_AVAILABILITY_GROUP_EVENTSDDL_AVAILABILITY_GROUP_EVENTS
1007110071 307307 ALTER_AVAILABILITY_GROUPALTER_AVAILABILITY_GROUP
1007110071 306306 CREATE_AVAILABILITY_GROUPCREATE_AVAILABILITY_GROUP
1007110071 308308 DROP_AVAILABILITY_GROUPDROP_AVAILABILITY_GROUP
1000210002 1000410004 DDL_DATABASE_EVENTSDDL_DATABASE_EVENTS
1000410004 202202 ALTER_DATABASEALTER_DATABASE
1000410004 201201 CREATE_DATABASECREATE_DATABASE
1000410004 203203 DROP_DATABASEDROP_DATABASE
1000210002 1000310003 DDL_ENDPOINT_EVENTSDDL_ENDPOINT_EVENTS
1000310003 182182 ALTER_ENDPOINTALTER_ENDPOINT
1000310003 181181 CREATE_ENDPOINTCREATE_ENDPOINT
1000310003 183183 DROP_ENDPOINTDROP_ENDPOINT
1000210002 1005710057 DDL_EVENT_SESSION_EVENTSDDL_EVENT_SESSION_EVENTS
1005710057 265265 ALTER_EVENT_SESSIONALTER_EVENT_SESSION
1005710057 264264 CREATE_EVENT_SESSIONCREATE_EVENT_SESSION
1005710057 266266 DROP_EVENT_SESSIONDROP_EVENT_SESSION
1000210002 1001110011 DDL_EXTENDED_PROCEDURE_EVENTSDDL_EXTENDED_PROCEDURE_EVENTS
1001110011 221221 CREATE_EXTENDED_PROCEDURECREATE_EXTENDED_PROCEDURE
1001110011 232232 DROP_EXTENDED_PROCEDUREDROP_EXTENDED_PROCEDURE
1000210002 1001210012 DDL_LINKED_SERVER_EVENTSDDL_LINKED_SERVER_EVENTS
1001210012 263263 ALTER_LINKED_SERVERALTER_LINKED_SERVER
1001210012 225225 CREATE_LINKED_SERVERCREATE_LINKED_SERVER
1001210012 1001310013 DDL_LINKED_SERVER_LOGIN_EVENTSDDL_LINKED_SERVER_LOGIN_EVENTS
1001310013 226226 CREATE_LINKED_SERVER_LOGINCREATE_LINKED_SERVER_LOGIN
1001310013 236236 DROP_LINKED_SERVER_LOGINDROP_LINKED_SERVER_LOGIN
1001210012 262262 DROP_LINKED_SERVERDROP_LINKED_SERVER
1000210002 1001410014 DDL_MESSAGE_EVENTSDDL_MESSAGE_EVENTS
1001410014 215215 ALTER_MESSAGEALTER_MESSAGE
1001410014 227227 CREATE_MESSAGECREATE_MESSAGE
1001410014 237237 DROP_MESSAGEDROP_MESSAGE
1000210002 1001510015 DDL_REMOTE_SERVER_EVENTSDDL_REMOTE_SERVER_EVENTS
1001510015 217217 ALTER_REMOTE_SERVERALTER_REMOTE_SERVER
1001510015 230230 CREATE_REMOTE_SERVERCREATE_REMOTE_SERVER
1001510015 240240 DROP_REMOTE_SERVERDROP_REMOTE_SERVER
1000210002 1005810058 DDL_RESOURCE_GOVERNOR_EVENTSDDL_RESOURCE_GOVERNOR_EVENTS
1005810058 273273 ALTER_RESOURCE_GOVERNOR_CONFIGALTER_RESOURCE_GOVERNOR_CONFIG
1005810058 1005910059 DDL_RESOURCE_POOLDDL_RESOURCE_POOL
1005910059 268268 ALTER_RESOURCE_POOLALTER_RESOURCE_POOL
1005910059 267267 CREATE_RESOURCE_POOLCREATE_RESOURCE_POOL
1005910059 269269 DROP_RESOURCE_POOLDROP_RESOURCE_POOL
1005810058 1006010060 DDL_WORKLOAD_GROUPDDL_WORKLOAD_GROUP
1006010060 271271 ALTER_WORKLOAD_GROUPALTER_WORKLOAD_GROUP
1006010060 270270 CREATE_WORKLOAD_GROUPCREATE_WORKLOAD_GROUP
1006010060 272272 DROP_WORKLOAD_GROUPDROP_WORKLOAD_GROUP
1000210002 1000510005 DDL_SERVER_SECURITY_EVENTSDDL_SERVER_SECURITY_EVENTS
1000510005 209209 ADD_SERVER_ROLE_MEMBERADD_SERVER_ROLE_MEMBER
1000510005 301301 ALTER_SERVER_ROLEALTER_SERVER_ROLE
1000510005 300300 CREATE_SERVER_ROLECREATE_SERVER_ROLE
1000510005 1000810008 DDL_AUTHORIZATION_SERVER_EVENTSDDL_AUTHORIZATION_SERVER_EVENTS
1000810008 204204 ALTER_AUTHORIZATION_SERVERALTER_AUTHORIZATION_SERVER
1000510005 1000910009 DDL_CREDENTIAL_EVENTSDDL_CREDENTIAL_EVENTS
1000910009 260260 ALTER_CREDENTIALALTER_CREDENTIAL
1000910009 259259 CREATE_CREDENTIALCREATE_CREDENTIAL
1000910009 261261 DROP_CREDENTIALDROP_CREDENTIAL
1000510005 1006110061 DDL_CRYPTOGRAPHIC_PROVIDER_EVENTSDDL_CRYPTOGRAPHIC_PROVIDER_EVENTS
1006110061 276276 ALTER_CRYPTOGRAPHIC_PROVIDERALTER_CRYPTOGRAPHIC_PROVIDER
1006110061 275275 CREATE_CRYPTOGRAPHIC_PROVIDERCREATE_CRYPTOGRAPHIC_PROVIDER
1006110061 277277 DROP_CRYPTOGRAPHIC_PROVIDERDROP_CRYPTOGRAPHIC_PROVIDER
1000510005 1000710007 DDL_GDR_SERVER_EVENTSDDL_GDR_SERVER_EVENTS
1000710007 168168 DENY_SERVERDENY_SERVER
1000710007 167167 GRANT_SERVERGRANT_SERVER
1000710007 169169 REVOKE_SERVERREVOKE_SERVER
1000510005 1000610006 DDL_LOGIN_EVENTSDDL_LOGIN_EVENTS
1000610006 145145 ALTER_LOGINALTER_LOGIN
1000610006 144144 CREATE_LOGINCREATE_LOGIN
1000610006 146146 DROP_LOGINDROP_LOGIN
1000510005 1006410064 DDL_SERVER_AUDIT_EVENTSDDL_SERVER_AUDIT_EVENTS
1006410064 285285 ALTER_SERVER_AUDITALTER_SERVER_AUDIT
1006410064 284284 CREATE_SERVER_AUDITCREATE_SERVER_AUDIT
1006410064 286286 DROP_SERVER_AUDITDROP_SERVER_AUDIT
1000510005 1006510065 DDL_SERVER_AUDIT_SPECIFICATION_EVENTSDDL_SERVER_AUDIT_SPECIFICATION_EVENTS
1006510065 288288 ALTER_SERVER_AUDIT_SPECIFICATIONALTER_SERVER_AUDIT_SPECIFICATION
1006510065 287287 CREATE_SERVER_AUDIT_SPECIFICATIONCREATE_SERVER_AUDIT_SPECIFICATION
1006510065 289289 DROP_SERVER_AUDIT_SPECIFICATIONDROP_SERVER_AUDIT_SPECIFICATION
1000510005 1001010010 DDL_SERVICE_MASTER_KEY_EVENTSDDL_SERVICE_MASTER_KEY_EVENTS
1001010010 251251 ALTER_SERVICE_MASTER_KEYALTER_SERVICE_MASTER_KEY
1000510005 302302 DROP_SERVER_ROLEDROP_SERVER_ROLE
1000510005 210210 DROP_SERVER_ROLE_MEMBERDROP_SERVER_ROLE_MEMBER

I dati sopra riportati possono essere creati eseguendo l'esempio di codice riportato di seguito.The data above can be created by running the following code example.

WITH DirectReports(name, parent_type, type, level, sort) AS   
(  
    SELECT CONVERT(varchar(255),type_name), parent_type, type, 1, CONVERT(varchar(255),type_name)  
    FROM sys.trigger_event_types   
    WHERE parent_type IS NULL  
    UNION ALL  
    SELECT  CONVERT(varchar(255), REPLICATE ('|   ' , level) + e.type_name),  
        e.parent_type, e.type, level + 1,  
    CONVERT (varchar(255), RTRIM(sort) + '|   ' + e.type_name)  
    FROM sys.trigger_event_types AS e  
        INNER JOIN DirectReports AS d  
        ON e.parent_type = d.type   
)  
SELECT parent_type, type, name  
FROM DirectReports  
ORDER BY sort;  

Vedere ancheSee Also

Notifiche degli eventi Event Notifications
Trigger DDL DDL Triggers
Eventi DDLDDL Events