gruppi di eventi DDLDDL Event Groups

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_EVENTS| DDL_DATABASE_LEVEL_EVENTS
1001610016 1002710027 | | DDL_ASSEMBLY_EVENTS| | DDL_ASSEMBLY_EVENTS
1002710027 102102 | | | ALTER_ASSEMBLY| | | ALTER_ASSEMBLY
1002710027 101101 | | | CREATE_ASSEMBLY| | | CREATE_ASSEMBLY
1002710027 103103 | | | DROP_ASSEMBLY| | | DROP_ASSEMBLY
1001610016 1002910029 | | DDL_DATABASE_SECURITY_EVENTS| | DDL_DATABASE_SECURITY_EVENTS
1002910029 1003310033 | | | DDL_APPLICATION_ROLE_EVENTS| | | DDL_APPLICATION_ROLE_EVENTS
1003310033 138138 | | | | ALTER_APPLICATION_ROLE| | | | ALTER_APPLICATION_ROLE
1003310033 137137 | | | | CREATE_APPLICATION_ROLE| | | | CREATE_APPLICATION_ROLE
1003310033 139139 | | | | DROP_APPLICATION_ROLE| | | | DROP_APPLICATION_ROLE
1002910029 1003810038 | | | DDL_ASYMMETRIC_KEY_EVENTS| | | DDL_ASYMMETRIC_KEY_EVENTS
1003810038 248248 | | | | ALTER_ASYMMETRIC_KEY| | | | ALTER_ASYMMETRIC_KEY
1003810038 247247 | | | | CREATE_ASYMMETRIC_KEY| | | | CREATE_ASYMMETRIC_KEY
1003810038 249249 | | | | DROP_ASYMMETRIC_KEY| | | | DROP_ASYMMETRIC_KEY
1002910029 1003610036 | | | DDL_AUTHORIZATION_DATABASE_EVENTS| | | DDL_AUTHORIZATION_DATABASE_EVENTS
1003610036 205205 | | | | ALTER_AUTHORIZATION_DATABASE| | | | ALTER_AUTHORIZATION_DATABASE
1002910029 1003010030 | | | DDL_CERTIFICATE_EVENTS| | | DDL_CERTIFICATE_EVENTS
1003010030 198198 | | | | ALTER_CERTIFICATE| | | | ALTER_CERTIFICATE
1003010030 197197 | | | | CREATE_CERTIFICATE| | | | CREATE_CERTIFICATE
1003010030 199199 | | | | DROP_CERTIFICATE| | | | DROP_CERTIFICATE
1002910029 1003910039 | | | DDL_CRYPTO_SIGNATURE_EVENTS| | | DDL_CRYPTO_SIGNATURE_EVENTS
1003910039 257257 | | | | ADD_SIGNATURE| | | | ADD_SIGNATURE
1003910039 255255 | | | | ADD_SIGNATURE_SCHEMA_OBJECT| | | | ADD_SIGNATURE_SCHEMA_OBJECT
1003910039 258258 | | | | DROP_SIGNATURE| | | | DROP_SIGNATURE
1003910039 256256 | | | | DROP_SIGNATURE_SCHEMA_OBJECT| | | | DROP_SIGNATURE_SCHEMA_OBJECT
1002910029 1006610066 | | | DDL_DATABASE_AUDIT_SPECIFICATION_EVENTS| | | DDL_DATABASE_AUDIT_SPECIFICATION_EVENTS
1006610066 291291 | | | | ALTER_DATABASE_AUDIT_SPECIFICATION| | | | ALTER_DATABASE_AUDIT_SPECIFICATION
1006610066 290290 | | | | CREATE_DATABASE_AUDIT_SPECIFICATION| | | | CREATE_DATABASE_AUDIT_SPECIFICATION
1006610066 292292 | | | | DROP_DATABASE_AUDIT_SPECIFICATION| | | | DROP_DATABASE_AUDIT_SPECIFICATION
1002910029 1006210062 | | | DDL_DATABASE_ENCRYPTION_KEY_EVENTS| | | DDL_DATABASE_ENCRYPTION_KEY_EVENTS
1006210062 279279 | | | | ALTER_DATABASE_ENCRYPTION_KEY| | | | ALTER_DATABASE_ENCRYPTION_KEY
1006210062 278278 | | | | CREATE_DATABASE_ENCRYPTION_KEY| | | | CREATE_DATABASE_ENCRYPTION_KEY
1006210062 280280 | | | | DROP_DATABASE_ENCRYPTION_KEY| | | | DROP_DATABASE_ENCRYPTION_KEY
1002910029 1003510035 | | | DDL_GDR_DATABASE_EVENTS| | | DDL_GDR_DATABASE_EVENTS
1003510035 171171 | | | | DENY_DATABASE| | | | DENY_DATABASE
1003510035 170170 | | | | GRANT_DATABASE| | | | GRANT_DATABASE
1003510035 172172 | | | | REVOKE_DATABASE| | | | REVOKE_DATABASE
1002910029 1004010040 | | | DDL_MASTER_KEY_EVENTS| | | DDL_MASTER_KEY_EVENTS
1004010040 253253 | | | | ALTER_MASTER_KEY| | | | ALTER_MASTER_KEY
1004010040 252252 | | | | CREATE_MASTER_KEY| | | | CREATE_MASTER_KEY
1004010040 254254 | | | | DROP_MASTER_KEY| | | | DROP_MASTER_KEY
1002910029 1003210032 | | | DDL_ROLE_EVENTS| | | DDL_ROLE_EVENTS
1003210032 207207 | | | | ADD_ROLE_MEMBER| | | | ADD_ROLE_MEMBER
1003210032 135135 | | | | ALTER_ROLE| | | | ALTER_ROLE
1003210032 134134 | | | | CREATE_ROLE| | | | CREATE_ROLE
1003210032 136136 | | | | DROP_ROLE| | | | DROP_ROLE
1003210032 208208 | | | | DROP_ROLE_MEMBER| | | | DROP_ROLE_MEMBER
1002910029 1003410034 | | | DDL_SCHEMA_EVENTS| | | DDL_SCHEMA_EVENTS
1003410034 142142 | | | | ALTER_SCHEMA| | | | ALTER_SCHEMA
1003410034 141141 | | | | CREATE_SCHEMA| | | | CREATE_SCHEMA
1003410034 143143 | | | | DROP_SCHEMA| | | | DROP_SCHEMA
1002910029 1003710037 | | | DDL_SYMMETRIC_KEY_EVENTS| | | DDL_SYMMETRIC_KEY_EVENTS
1003710037 245245 | | | | ALTER_SYMMETRIC_KEY| | | | ALTER_SYMMETRIC_KEY
1003710037 244244 | | | | CREATE_SYMMETRIC_KEY| | | | CREATE_SYMMETRIC_KEY
1003710037 246246 | | | | DROP_SYMMETRIC_KEY| | | | DROP_SYMMETRIC_KEY
1002910029 1003110031 | | | DDL_USER_EVENTS| | | DDL_USER_EVENTS
1003110031 132132 | | | | ALTER_USER| | | | ALTER_USER
1003110031 131131 | | | | CREATE_USER| | | | CREATE_USER
1003110031 133133 | | | | DROP_USER| | | | DROP_USER
1001610016 1005210052 | | DDL_DEFAULT_EVENTS| | DDL_DEFAULT_EVENTS
1005210052 218218 | | | BIND_DEFAULT| | | BIND_DEFAULT
1005210052 220220 | | | CREATE_DEFAULT| | | CREATE_DEFAULT
1005210052 231231 | | | DROP_DEFAULT| | | DROP_DEFAULT
1005210052 242242 | | | UNBIND_DEFAULT| | | UNBIND_DEFAULT
1001610016 1002610026 | | DDL_EVENT_NOTIFICATION_EVENTS| | DDL_EVENT_NOTIFICATION_EVENTS
1002610026 7474 | | | CREATE_EVENT_NOTIFICATION| | | CREATE_EVENT_NOTIFICATION
1002610026 7676 | | | DROP_EVENT_NOTIFICATION| | | DROP_EVENT_NOTIFICATION
1001610016 1005310053 | | DDL_EXTENDED_PROPERTY_EVENTS| | DDL_EXTENDED_PROPERTY_EVENTS
1005310053 211211 | | | ALTER_EXTENDED_PROPERTY| | | ALTER_EXTENDED_PROPERTY
1005310053 222222 | | | CREATE_EXTENDED_PROPERTY| | | CREATE_EXTENDED_PROPERTY
1005310053 233233 | | | DROP_EXTENDED_PROPERTY| | | DROP_EXTENDED_PROPERTY
1001610016 1005410054 | | DDL_FULLTEXT_CATALOG_EVENTS| | DDL_FULLTEXT_CATALOG_EVENTS
1005410054 212212 | | | ALTER_FULLTEXT_CATALOG| | | ALTER_FULLTEXT_CATALOG
1005410054 223223 | | | CREATE_FULLTEXT_CATALOG| | | CREATE_FULLTEXT_CATALOG
1005410054 234234 | | | DROP_FULLTEXT_CATALOG| | | DROP_FULLTEXT_CATALOG
1001610016 1006710067 | | DDL_FULLTEXT_STOPLIST_EVENTS| | DDL_FULLTEXT_STOPLIST_EVENTS
1006710067 294294 | | | ALTER_FULLTEXT_STOPLIST| | | ALTER_FULLTEXT_STOPLIST
1006710067 293293 | | | CREATE_FULLTEXT_STOPLIST| | | CREATE_FULLTEXT_STOPLIST
1006710067 295295 | | | DROP_FULLTEXT_STOPLIST| | | DROP_FULLTEXT_STOPLIST
1001610016 1002310023 | | DDL_FUNCTION_EVENTS| | DDL_FUNCTION_EVENTS
1002310023 6262 | | | ALTER_FUNCTION| | | ALTER_FUNCTION
1002310023 6161 | | | CREATE_FUNCTION| | | CREATE_FUNCTION
1002310023 6363 | | | DROP_FUNCTION| | | DROP_FUNCTION
1001610016 1004910049 | | DDL_PARTITION_EVENTS| | DDL_PARTITION_EVENTS
1004910049 1005010050 | | | DDL_PARTITION_FUNCTION_EVENTS| | | DDL_PARTITION_FUNCTION_EVENTS
1005010050 192192 | | | | ALTER_PARTITION_FUNCTION| | | | ALTER_PARTITION_FUNCTION
1005010050 191191 | | | | CREATE_PARTITION_FUNCTION| | | | CREATE_PARTITION_FUNCTION
1005010050 193193 | | | | DROP_PARTITION_FUNCTION| | | | DROP_PARTITION_FUNCTION
1004910049 1005110051 | | | DDL_PARTITION_SCHEME_EVENTS| | | DDL_PARTITION_SCHEME_EVENTS
1005110051 195195 | | | | ALTER_PARTITION_SCHEME| | | | ALTER_PARTITION_SCHEME
1005110051 194194 | | | | CREATE_PARTITION_SCHEME| | | | CREATE_PARTITION_SCHEME
1005110051 196196 | | | | DROP_PARTITION_SCHEME| | | | DROP_PARTITION_SCHEME
1001610016 1005510055 | | DDL_PLAN_GUIDE_EVENTS| | DDL_PLAN_GUIDE_EVENTS
1005510055 216216 | | | ALTER_PLAN_GUIDE| | | ALTER_PLAN_GUIDE
1005510055 228228 | | | CREATE_PLAN_GUIDE| | | CREATE_PLAN_GUIDE
1005510055 238238 | | | DROP_PLAN_GUIDE| | | DROP_PLAN_GUIDE
1001610016 1002410024 | | DDL_PROCEDURE_EVENTS| | DDL_PROCEDURE_EVENTS
1002410024 5252 | | | ALTER_PROCEDURE| | | ALTER_PROCEDURE
1002410024 5151 | | | CREATE_PROCEDURE| | | CREATE_PROCEDURE
1002410024 5353 | | | DROP_PROCEDURE| | | DROP_PROCEDURE
1001610016 1005610056 | | DDL_RULE_EVENTS| | DDL_RULE_EVENTS
1005610056 219219 | | | BIND_RULE| | | BIND_RULE
1005610056 229229 | | | CREATE_RULE| | | CREATE_RULE
1005610056 239239 | | | DROP_RULE| | | DROP_RULE
1005610056 243243 | | | UNBIND_RULE| | | UNBIND_RULE
1001610016 1006910069 | | DDL_SEARCH_PROPERTY_LIST_EVENTS| | DDL_SEARCH_PROPERTY_LIST_EVENTS
1006910069 298298 | | | ALTER_SEARCH_PROPERTY_LIST| | | ALTER_SEARCH_PROPERTY_LIST
1006910069 297297 | | | CREATE_SEARCH_PROPERTY_LIST| | | CREATE_SEARCH_PROPERTY_LIST
1006910069 299299 | | | DROP_SEARCH_PROPERTY_LIST| | | DROP_SEARCH_PROPERTY_LIST
1001610016 1007010070 | | DDL_SEQUENCE_EVENTS| | DDL_SEQUENCE_EVENTS
1007010070 304304 | | | ALTER_SEQUENCE| | | ALTER_SEQUENCE
1007010070 303303 | | | CREATE_SEQUENCE| | | CREATE_SEQUENCE
1007010070 305305 | | | DROP_SEQUENCE| | | DROP_SEQUENCE
1001610016 1004110041 | | DDL_SSB_EVENTS| | DDL_SSB_EVENTS
1004110041 1006310063 | | | DDL_BROKER_PRIORITY_EVENTS| | | DDL_BROKER_PRIORITY_EVENTS
1006310063 282282 | | | | ALTER_BROKER_PRIORITY| | | | ALTER_BROKER_PRIORITY
1006310063 281281 | | | | CREATE_BROKER_PRIORITY| | | | CREATE_BROKER_PRIORITY
1006310063 283283 | | | | DROP_BROKER_PRIORITY| | | | DROP_BROKER_PRIORITY
1004110041 1004310043 | | | DDL_CONTRACT_EVENTS| | | DDL_CONTRACT_EVENTS
1004310043 154154 | | | | CREATE_CONTRACT| | | | CREATE_CONTRACT
1004310043 156156 | | | | DROP_CONTRACT| | | | DROP_CONTRACT
1004110041 1004210042 | | | DDL_MESSAGE_TYPE_EVENTS| | | DDL_MESSAGE_TYPE_EVENTS
1004210042 152152 | | | | ALTER_MESSAGE_TYPE| | | | ALTER_MESSAGE_TYPE
1004210042 151151 | | | | CREATE_MESSAGE_TYPE| | | | CREATE_MESSAGE_TYPE
1004210042 153153 | | | | DROP_MESSAGE_TYPE| | | | DROP_MESSAGE_TYPE
1004110041 1004410044 | | | DDL_QUEUE_EVENTS| | | DDL_QUEUE_EVENTS
1004410044 158158 | | | | ALTER_QUEUE| | | | ALTER_QUEUE
1004410044 157157 | | | | CREATE_QUEUE| | | | CREATE_QUEUE
1004410044 159159 | | | | DROP_QUEUE| | | | DROP_QUEUE
1004110041 1004710047 | | | DDL_REMOTE_SERVICE_BINDING_EVENTS| | | DDL_REMOTE_SERVICE_BINDING_EVENTS
1004710047 175175 | | | | ALTER_REMOTE_SERVICE_BINDING| | | | ALTER_REMOTE_SERVICE_BINDING
1004710047 174174 | | | | CREATE_REMOTE_SERVICE_BINDING| | | | CREATE_REMOTE_SERVICE_BINDING
1004710047 176176 | | | | DROP_REMOTE_SERVICE_BINDING| | | | DROP_REMOTE_SERVICE_BINDING
1004110041 1004610046 | | | DDL_ROUTE_EVENTS| | | DDL_ROUTE_EVENTS
1004610046 165165 | | | | ALTER_ROUTE| | | | ALTER_ROUTE
1004610046 164164 | | | | CREATE_ROUTE| | | | CREATE_ROUTE
1004610046 166166 | | | | DROP_ROUTE| | | | DROP_ROUTE
1004110041 1004510045 | | | DDL_SERVICE_EVENTS| | | DDL_SERVICE_EVENTS
1004510045 162162 | | | | ALTER_SERVICE| | | | ALTER_SERVICE
1004510045 161161 | | | | CREATE_SERVICE| | | | CREATE_SERVICE
1004510045 163163 | | | | DROP_SERVICE| | | | DROP_SERVICE
1001610016 1002210022 | | DDL_SYNONYM_EVENTS| | DDL_SYNONYM_EVENTS
1002210022 3434 | | | CREATE_SYNONYM| | | CREATE_SYNONYM
1002210022 3636 | | | DROP_SYNONYM| | | DROP_SYNONYM
1001610016 1001710017 | | DDL_TABLE_VIEW_EVENTS| | DDL_TABLE_VIEW_EVENTS
1001710017 1002010020 | | | DDL_INDEX_EVENTS| | | DDL_INDEX_EVENTS
1002010020 213213 | | | | ALTER_FULLTEXT_INDEX| | | | ALTER_FULLTEXT_INDEX
1002010020 2525 | | | | ALTER_INDEX| | | | ALTER_INDEX
1002010020 224224 | | | | CREATE_FULLTEXT_INDEX| | | | CREATE_FULLTEXT_INDEX
1002010020 2424 | | | | CREATE_INDEX| | | | CREATE_INDEX
1002010020 274274 | | | | CREATE_SPATIAL_INDEX| | | | CREATE_SPATIAL_INDEX
1002010020 206206 | | | | CREATE_XML_INDEX| | | | CREATE_XML_INDEX
1002010020 235235 | | | | DROP_FULLTEXT_INDEX| | | | DROP_FULLTEXT_INDEX
1002010020 2626 | | | | DROP_INDEX| | | | DROP_INDEX
1001710017 1002110021 | | | DDL_STATISTICS_EVENTS| | | DDL_STATISTICS_EVENTS
1002110021 2727 | | | | CREATE_STATISTICS| | | | CREATE_STATISTICS
1002110021 2929 | | | | DROP_STATISTICS| | | | DROP_STATISTICS
1002110021 2828 | | | | UPDATE_STATISTICS| | | | UPDATE_STATISTICS
1001710017 1001810018 | | | DDL_TABLE_EVENTS| | | DDL_TABLE_EVENTS
1001810018 2222 | | | | ALTER_TABLE| | | | ALTER_TABLE
1001810018 2121 | | | | CREATE_TABLE| | | | CREATE_TABLE
1001810018 2323 | | | | DROP_TABLE| | | | DROP_TABLE
1001710017 1001910019 | | | DDL_VIEW_EVENTS| | | DDL_VIEW_EVENTS
1001910019 4242 | | | | ALTER_VIEW| | | | ALTER_VIEW
1001910019 4141 | | | | CREATE_VIEW| | | | CREATE_VIEW
1001910019 4343 | | | | DROP_VIEW| | | | DROP_VIEW
1001610016 1002510025 | | DDL_TRIGGER_EVENTS| | DDL_TRIGGER_EVENTS
1002510025 7272 | | | ALTER_TRIGGER| | | ALTER_TRIGGER
1002510025 7171 | | | CREATE_TRIGGER| | | CREATE_TRIGGER
1002510025 7373 | | | DROP_TRIGGER| | | DROP_TRIGGER
1001610016 1002810028 | | DDL_TYPE_EVENTS| | DDL_TYPE_EVENTS
1002810028 9191 | | | CREATE_TYPE| | | CREATE_TYPE
1002810028 9393 | | | DROP_TYPE| | | DROP_TYPE
1001610016 1004810048 | | DDL_XML_SCHEMA_COLLECTION_EVENTS| | DDL_XML_SCHEMA_COLLECTION_EVENTS
1004810048 178178 | | | ALTER_XML_SCHEMA_COLLECTION| | | ALTER_XML_SCHEMA_COLLECTION
1004810048 177177 | | | CREATE_XML_SCHEMA_COLLECTION| | | CREATE_XML_SCHEMA_COLLECTION
1004810048 179179 | | | DROP_XML_SCHEMA_COLLECTION| | | DROP_XML_SCHEMA_COLLECTION
1001610016 241241 | | RENAME| | RENAME
1000110001 1000210002 | DDL_SERVER_LEVEL_EVENTS| DDL_SERVER_LEVEL_EVENTS
1000210002 214214 | | ALTER_INSTANCE| | ALTER_INSTANCE
1000210002 1007110071 | | DDL_AVAILABILITY_GROUP_EVENTS| | DDL_AVAILABILITY_GROUP_EVENTS
1007110071 307307 | | | ALTER_AVAILABILITY_GROUP| | | ALTER_AVAILABILITY_GROUP
1007110071 306306 | | | CREATE_AVAILABILITY_GROUP| | | CREATE_AVAILABILITY_GROUP
1007110071 308308 | | | DROP_AVAILABILITY_GROUP| | | DROP_AVAILABILITY_GROUP
1000210002 1000410004 | | DDL_DATABASE_EVENTS| | DDL_DATABASE_EVENTS
1000410004 202202 | | | ALTER_DATABASE| | | ALTER_DATABASE
1000410004 201201 | | | CREATE_DATABASE| | | CREATE_DATABASE
1000410004 203203 | | | DROP_DATABASE| | | DROP_DATABASE
1000210002 1000310003 | | DDL_ENDPOINT_EVENTS| | DDL_ENDPOINT_EVENTS
1000310003 182182 | | | ALTER_ENDPOINT| | | ALTER_ENDPOINT
1000310003 181181 | | | CREATE_ENDPOINT| | | CREATE_ENDPOINT
1000310003 183183 | | | DROP_ENDPOINT| | | DROP_ENDPOINT
1000210002 1005710057 | | DDL_EVENT_SESSION_EVENTS| | DDL_EVENT_SESSION_EVENTS
1005710057 265265 | | | ALTER_EVENT_SESSION| | | ALTER_EVENT_SESSION
1005710057 264264 | | | CREATE_EVENT_SESSION| | | CREATE_EVENT_SESSION
1005710057 266266 | | | DROP_EVENT_SESSION| | | DROP_EVENT_SESSION
1000210002 1001110011 | | DDL_EXTENDED_PROCEDURE_EVENTS| | DDL_EXTENDED_PROCEDURE_EVENTS
1001110011 221221 | | | CREATE_EXTENDED_PROCEDURE| | | CREATE_EXTENDED_PROCEDURE
1001110011 232232 | | | DROP_EXTENDED_PROCEDURE| | | DROP_EXTENDED_PROCEDURE
1000210002 1001210012 | | DDL_LINKED_SERVER_EVENTS| | DDL_LINKED_SERVER_EVENTS
1001210012 263263 | | | ALTER_LINKED_SERVER| | | ALTER_LINKED_SERVER
1001210012 225225 | | | CREATE_LINKED_SERVER| | | CREATE_LINKED_SERVER
1001210012 1001310013 | | | DDL_LINKED_SERVER_LOGIN_EVENTS| | | DDL_LINKED_SERVER_LOGIN_EVENTS
1001310013 226226 | | | | CREATE_LINKED_SERVER_LOGIN| | | | CREATE_LINKED_SERVER_LOGIN
1001310013 236236 | | | | DROP_LINKED_SERVER_LOGIN| | | | DROP_LINKED_SERVER_LOGIN
1001210012 262262 | | | DROP_LINKED_SERVER| | | DROP_LINKED_SERVER
1000210002 1001410014 | | DDL_MESSAGE_EVENTS| | DDL_MESSAGE_EVENTS
1001410014 215215 | | | ALTER_MESSAGE| | | ALTER_MESSAGE
1001410014 227227 | | | CREATE_MESSAGE| | | CREATE_MESSAGE
1001410014 237237 | | | DROP_MESSAGE| | | DROP_MESSAGE
1000210002 1001510015 | | DDL_REMOTE_SERVER_EVENTS| | DDL_REMOTE_SERVER_EVENTS
1001510015 217217 | | | ALTER_REMOTE_SERVER| | | ALTER_REMOTE_SERVER
1001510015 230230 | | | CREATE_REMOTE_SERVER| | | CREATE_REMOTE_SERVER
1001510015 240240 | | | DROP_REMOTE_SERVER| | | DROP_REMOTE_SERVER
1000210002 1005810058 | | DDL_RESOURCE_GOVERNOR_EVENTS| | DDL_RESOURCE_GOVERNOR_EVENTS
1005810058 273273 | | | ALTER_RESOURCE_GOVERNOR_CONFIG| | | ALTER_RESOURCE_GOVERNOR_CONFIG
1005810058 1005910059 | | | DDL_RESOURCE_POOL| | | DDL_RESOURCE_POOL
1005910059 268268 | | | | ALTER_RESOURCE_POOL| | | | ALTER_RESOURCE_POOL
1005910059 267267 | | | | CREATE_RESOURCE_POOL| | | | CREATE_RESOURCE_POOL
1005910059 269269 | | | | DROP_RESOURCE_POOL| | | | DROP_RESOURCE_POOL
1005810058 1006010060 | | | DDL_WORKLOAD_GROUP| | | DDL_WORKLOAD_GROUP
1006010060 271271 | | | | ALTER_WORKLOAD_GROUP| | | | ALTER_WORKLOAD_GROUP
1006010060 270270 | | | | CREATE_WORKLOAD_GROUP| | | | CREATE_WORKLOAD_GROUP
1006010060 272272 | | | | DROP_WORKLOAD_GROUP| | | | DROP_WORKLOAD_GROUP
1000210002 1000510005 | | DDL_SERVER_SECURITY_EVENTS| | DDL_SERVER_SECURITY_EVENTS
1000510005 209209 | | | ADD_SERVER_ROLE_MEMBER| | | ADD_SERVER_ROLE_MEMBER
1000510005 301301 | | | ALTER_SERVER_ROLE| | | ALTER_SERVER_ROLE
1000510005 300300 | | | CREATE_SERVER_ROLE| | | CREATE_SERVER_ROLE
1000510005 1000810008 | | | DDL_AUTHORIZATION_SERVER_EVENTS| | | DDL_AUTHORIZATION_SERVER_EVENTS
1000810008 204204 | | | | ALTER_AUTHORIZATION_SERVER| | | | ALTER_AUTHORIZATION_SERVER
1000510005 1000910009 | | | DDL_CREDENTIAL_EVENTS| | | DDL_CREDENTIAL_EVENTS
1000910009 260260 | | | | ALTER_CREDENTIAL| | | | ALTER_CREDENTIAL
1000910009 259259 | | | | CREATE_CREDENTIAL| | | | CREATE_CREDENTIAL
1000910009 261261 | | | | DROP_CREDENTIAL| | | | DROP_CREDENTIAL
1000510005 1006110061 | | | DDL_CRYPTOGRAPHIC_PROVIDER_EVENTS| | | DDL_CRYPTOGRAPHIC_PROVIDER_EVENTS
1006110061 276276 | | | | ALTER_CRYPTOGRAPHIC_PROVIDER| | | | ALTER_CRYPTOGRAPHIC_PROVIDER
1006110061 275275 | | | | CREATE_CRYPTOGRAPHIC_PROVIDER| | | | CREATE_CRYPTOGRAPHIC_PROVIDER
1006110061 277277 | | | | DROP_CRYPTOGRAPHIC_PROVIDER| | | | DROP_CRYPTOGRAPHIC_PROVIDER
1000510005 1000710007 | | | DDL_GDR_SERVER_EVENTS| | | DDL_GDR_SERVER_EVENTS
1000710007 168168 | | | | DENY_SERVER| | | | DENY_SERVER
1000710007 167167 | | | | GRANT_SERVER| | | | GRANT_SERVER
1000710007 169169 | | | | REVOKE_SERVER| | | | REVOKE_SERVER
1000510005 1000610006 | | | DDL_LOGIN_EVENTS| | | DDL_LOGIN_EVENTS
1000610006 145145 | | | | ALTER_LOGIN| | | | ALTER_LOGIN
1000610006 144144 | | | | CREATE_LOGIN| | | | CREATE_LOGIN
1000610006 146146 | | | | DROP_LOGIN| | | | DROP_LOGIN
1000510005 1006410064 | | | DDL_SERVER_AUDIT_EVENTS| | | DDL_SERVER_AUDIT_EVENTS
1006410064 285285 | | | | ALTER_SERVER_AUDIT| | | | ALTER_SERVER_AUDIT
1006410064 284284 | | | | CREATE_SERVER_AUDIT| | | | CREATE_SERVER_AUDIT
1006410064 286286 | | | | DROP_SERVER_AUDIT| | | | DROP_SERVER_AUDIT
1000510005 1006510065 | | | DDL_SERVER_AUDIT_SPECIFICATION_EVENTS| | | DDL_SERVER_AUDIT_SPECIFICATION_EVENTS
1006510065 288288 | | | | ALTER_SERVER_AUDIT_SPECIFICATION| | | | ALTER_SERVER_AUDIT_SPECIFICATION
1006510065 287287 | | | | CREATE_SERVER_AUDIT_SPECIFICATION| | | | CREATE_SERVER_AUDIT_SPECIFICATION
1006510065 289289 | | | | DROP_SERVER_AUDIT_SPECIFICATION| | | | DROP_SERVER_AUDIT_SPECIFICATION
1000510005 1001010010 | | | DDL_SERVICE_MASTER_KEY_EVENTS| | | DDL_SERVICE_MASTER_KEY_EVENTS
1001010010 251251 | | | | ALTER_SERVICE_MASTER_KEY| | | | ALTER_SERVICE_MASTER_KEY
1000510005 302302 | | | DROP_SERVER_ROLE| | | DROP_SERVER_ROLE
1000510005 210210 | | | DROP_SERVER_ROLE_MEMBER| | | DROP_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 DDL DDL Events