// ************************************************************************** // Copyright (c) 2001-2004 Microsoft Corporation. // // @File: sqlwep.mof // // Description: // // Defines event class for events generated by this provider. // Also defines instances needed for registration of this // event provider with WMI. // // Notes: // This file is AUTOGENERATED. Please, don't do any manual changes here. // If you need to do some changes, change one of the following files: // mofgen.txt, mofgen.pl, eventsschema.cpp // // History: // // @Version: Yukon // 000000 ISP 03/11/02 ... // // @EndHeader@ // ************************************************************************** //------------------- // Autorecover Pragma //------------------- // WMI checks the integrity of the CIM repository when the Windows Management // Service is started. If the repository is damaged, WMI automatically rebuilds // it and recompiles any MOF files listed in the autorecover key in the registry, // shown next: // // HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WBEM\CIMOM\autorecover mofs. // // The MOF files listed in this registry entry must reside on the local computer // because MOF files that have the autorecover command cannot recover MOF files // located on a remote computer. #pragma autorecover //---------------------------------- // Create the Microsoft subnamespace //---------------------------------- #pragma namespace ("\\\\.\\root") instance of __Namespace { Name = "Microsoft"; }; //---------------------------------- // Create the SqlServer subnamespace //---------------------------------- #pragma namespace ("\\\\.\\root\\Microsoft") instance of __Namespace { Name = "SqlServer"; }; //------------------------------------- // Create the ServerEvents subnamespace //------------------------------------- #pragma namespace ("\\\\.\\root\\Microsoft\\SqlServer") instance of __Namespace { Name = "ServerEvents"; }; //------------------------------------------------------ // Connects to \\.\root\Microsoft\SqlServer\ServerEvents //------------------------------------------------------ #pragma namespace ("\\\\.\\root\\Microsoft\\SqlServer\\ServerEvents") //------------------------------------- // Create the InstanceName subnamespace //------------------------------------- // Create InstanceName subnamespace //------------------------------------------------------------------- // Connects to \\.\root\Microsoft\SqlServer\ServerEvents\InstanceName //------------------------------------------------------------------- // Use InstanceName subnamespace #pragma deleteclass( "ALL_EVENTS", NOFAIL ) class ALL_EVENTS : __ExtrinsicEvent { Sint32 SPID; String ComputerName; String SQLInstance; DateTime PostTime; }; #pragma deleteclass( "DDL_EVENTS", NOFAIL ) class DDL_EVENTS : ALL_EVENTS { String LoginName; }; #pragma deleteclass( "TRC_ALL_EVENTS", NOFAIL ) class TRC_ALL_EVENTS : ALL_EVENTS { Sint32 EventSequence; String SessionLoginName; }; #pragma deleteclass( "DDL_DATABASE_LEVEL_EVENTS", NOFAIL ) class DDL_DATABASE_LEVEL_EVENTS : DDL_EVENTS { String UserName; String DatabaseName; }; #pragma deleteclass( "TRC_USER_CONFIGURABLE", NOFAIL ) class TRC_USER_CONFIGURABLE : TRC_ALL_EVENTS { String TextData; Sint64 TransactionID; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; Uint8 LoginSid[]; String NTDomainName; Sint32 IsSystem; Sint32 DatabaseID; String HostName; String NTUserName; Uint8 BinaryData[]; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "TRC_OBJECTS", NOFAIL ) class TRC_OBJECTS : TRC_ALL_EVENTS { Sint64 TransactionID; Sint32 IndexID; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; Uint8 LoginSid[]; String NTDomainName; Sint32 ObjectID; String ObjectName; Sint64 ObjectID2; Sint32 IsSystem; Sint32 DatabaseID; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; String HostName; String NTUserName; Sint32 IntegerData; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "DDL_SERVER_LEVEL_EVENTS", NOFAIL ) class DDL_SERVER_LEVEL_EVENTS : DDL_EVENTS { }; #pragma deleteclass( "TRC_ERRORS_AND_WARNINGS", NOFAIL ) class TRC_ERRORS_AND_WARNINGS : TRC_ALL_EVENTS { Sint64 TransactionID; Uint8 LoginSid[]; Sint32 IsSystem; Sint32 DatabaseID; }; #pragma deleteclass( "TRC_DEPRECATION", NOFAIL ) class TRC_DEPRECATION : TRC_ALL_EVENTS { Sint32 Offset; String TextData; Sint64 TransactionID; String LoginName; Uint8 SqlHandle[]; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; Uint8 LoginSid[]; String NTDomainName; Sint32 IsSystem; Sint32 DatabaseID; Sint32 IntegerData2; Sint64 XactSequence; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "TRC_QUERY_NOTIFICATIONS", NOFAIL ) class TRC_QUERY_NOTIFICATIONS : TRC_ALL_EVENTS { String TextData; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; Uint8 LoginSid[]; String NTDomainName; Sint32 IsSystem; Sint32 DatabaseID; Sint32 EventSubClass; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "TRC_DATABASE", NOFAIL ) class TRC_DATABASE : TRC_ALL_EVENTS { String DatabaseName; Uint8 LoginSid[]; Sint32 IsSystem; Sint32 DatabaseID; Sint32 IntegerData; DateTime StartTime; }; #pragma deleteclass( "TRC_OLEDB", NOFAIL ) class TRC_OLEDB : TRC_ALL_EVENTS { String TextData; Sint64 TransactionID; String LinkedServerName; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; Uint8 LoginSid[]; String NTDomainName; Sint32 IsSystem; Sint32 DatabaseID; String HostName; String NTUserName; String ProviderName; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "TRC_STORED_PROCEDURES", NOFAIL ) class TRC_STORED_PROCEDURES : TRC_ALL_EVENTS { String TextData; Sint64 TransactionID; String LoginName; String ApplicationName; Sint32 ClientProcessID; Uint8 LoginSid[]; String NTDomainName; Sint32 ObjectID; Sint32 IsSystem; Sint32 DatabaseID; Sint32 ObjectType; Sint64 XactSequence; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "TRC_TSQL", NOFAIL ) class TRC_TSQL : TRC_ALL_EVENTS { String TextData; Sint64 TransactionID; Sint32 LineNumber; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; Uint8 LoginSid[]; String NTDomainName; Sint32 IsSystem; Sint32 DatabaseID; Sint64 XactSequence; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "TRC_FULL_TEXT", NOFAIL ) class TRC_FULL_TEXT : TRC_ALL_EVENTS { Sint64 TransactionID; Sint32 ObjectID; Sint32 IsSystem; Sint32 DatabaseID; DateTime StartTime; }; #pragma deleteclass( "TRC_SECURITY_AUDIT", NOFAIL ) class TRC_SECURITY_AUDIT : TRC_ALL_EVENTS { String LoginName; String ApplicationName; String DatabaseName; String NTDomainName; Sint32 IsSystem; Sint32 Success; Sint32 DatabaseID; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "TRC_SERVER", NOFAIL ) class TRC_SERVER : TRC_ALL_EVENTS { Sint32 IsSystem; DateTime StartTime; }; #pragma deleteclass( "TRC_PERFORMANCE", NOFAIL ) class TRC_PERFORMANCE : TRC_ALL_EVENTS { Sint32 NestLevel; Sint64 TransactionID; Sint32 LineNumber; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; Uint8 LoginSid[]; String NTDomainName; Sint32 ObjectID; String ObjectName; Sint32 IsSystem; Sint32 DatabaseID; Sint32 ObjectType; Sint64 XactSequence; String HostName; Uint8 BinaryData[]; Sint32 IntegerData; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "TRC_CLR", NOFAIL ) class TRC_CLR : TRC_ALL_EVENTS { }; #pragma deleteclass( "TRC_LOCKS", NOFAIL ) class TRC_LOCKS : TRC_ALL_EVENTS { Sint64 TransactionID; Uint8 LoginSid[]; Sint32 IsSystem; DateTime StartTime; }; #pragma deleteclass( "DDL_TRIGGER_EVENTS", NOFAIL ) class DDL_TRIGGER_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String SchemaName; String TargetObjectName; String ObjectType; String ObjectName; String TSQLCommand; String TargetObjectType; }; #pragma deleteclass( "DDL_FUNCTION_EVENTS", NOFAIL ) class DDL_FUNCTION_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String SchemaName; String ObjectType; String ObjectName; String TSQLCommand; }; #pragma deleteclass( "DDL_ENDPOINT_EVENTS", NOFAIL ) class DDL_ENDPOINT_EVENTS : DDL_SERVER_LEVEL_EVENTS { String ObjectType; String ObjectName; String TSQLCommand; }; #pragma deleteclass( "DDL_SYNONYM_EVENTS", NOFAIL ) class DDL_SYNONYM_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String SchemaName; String TargetObjectName; String TargetServerName; String ObjectType; String TargetSchemaName; String ObjectName; String TSQLCommand; String TargetDatabaseName; }; #pragma deleteclass( "DDL_SSB_EVENTS", NOFAIL ) class DDL_SSB_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String ObjectType; String ObjectName; String TSQLCommand; }; #pragma deleteclass( "DDL_DATABASE_SECURITY_EVENTS", NOFAIL ) class DDL_DATABASE_SECURITY_EVENTS : DDL_DATABASE_LEVEL_EVENTS { }; #pragma deleteclass( "DDL_EVENT_NOTIFICATION_EVENTS", NOFAIL ) class DDL_EVENT_NOTIFICATION_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String TargetObjectName; String ObjectType; String TargetSchemaName; String ObjectName; String TSQLCommand; String TargetObjectType; }; #pragma deleteclass( "DDL_PROCEDURE_EVENTS", NOFAIL ) class DDL_PROCEDURE_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String SchemaName; String ObjectType; String ObjectName; String TSQLCommand; }; #pragma deleteclass( "DDL_SERVER_SECURITY_EVENTS", NOFAIL ) class DDL_SERVER_SECURITY_EVENTS : DDL_SERVER_LEVEL_EVENTS { }; #pragma deleteclass( "DDL_TABLE_VIEW_EVENTS", NOFAIL ) class DDL_TABLE_VIEW_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String SchemaName; String ObjectType; String TSQLCommand; }; #pragma deleteclass( "DDL_TYPE_EVENTS", NOFAIL ) class DDL_TYPE_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String SchemaName; String ObjectType; String ObjectName; String TSQLCommand; }; #pragma deleteclass( "DDL_XML_SCHEMA_COLLECTION_EVENTS", NOFAIL ) class DDL_XML_SCHEMA_COLLECTION_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String SchemaName; String ObjectType; String ObjectName; String TSQLCommand; }; #pragma deleteclass( "DDL_PARTITION_EVENTS", NOFAIL ) class DDL_PARTITION_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String ObjectType; String ObjectName; String TSQLCommand; }; #pragma deleteclass( "DDL_ASSEMBLY_EVENTS", NOFAIL ) class DDL_ASSEMBLY_EVENTS : DDL_DATABASE_LEVEL_EVENTS { String ObjectType; String ObjectName; String TSQLCommand; }; #pragma deleteclass( "DDL_LOGIN_EVENTS", NOFAIL ) class DDL_LOGIN_EVENTS : DDL_SERVER_SECURITY_EVENTS { String ObjectType; String ObjectName; String LoginType; String DefaultDatabase; Uint8 SID[]; String DefaultLanguage; }; #pragma deleteclass( "DDL_STATISTICS_EVENTS", NOFAIL ) class DDL_STATISTICS_EVENTS : DDL_TABLE_VIEW_EVENTS { String TargetObjectName; String TargetObjectType; }; #pragma deleteclass( "DDL_GDR_SERVER_EVENTS", NOFAIL ) class DDL_GDR_SERVER_EVENTS : DDL_SERVER_SECURITY_EVENTS { String AsGrantor; String Grantor; Boolean GrantOption; String Permissions; String TSQLCommand; String Grantees; Boolean CascadeOption; }; #pragma deleteclass( "DDL_VIEW_EVENTS", NOFAIL ) class DDL_VIEW_EVENTS : DDL_TABLE_VIEW_EVENTS { String ObjectName; }; #pragma deleteclass( "DDL_AUTHORIZATION_SERVER_EVENTS", NOFAIL ) class DDL_AUTHORIZATION_SERVER_EVENTS : DDL_SERVER_SECURITY_EVENTS { }; #pragma deleteclass( "DDL_REMOTE_SERVICE_BINDING_EVENTS", NOFAIL ) class DDL_REMOTE_SERVICE_BINDING_EVENTS : DDL_SSB_EVENTS { }; #pragma deleteclass( "DDL_CONTRACT_EVENTS", NOFAIL ) class DDL_CONTRACT_EVENTS : DDL_SSB_EVENTS { }; #pragma deleteclass( "DDL_INDEX_EVENTS", NOFAIL ) class DDL_INDEX_EVENTS : DDL_TABLE_VIEW_EVENTS { String TargetObjectName; String ObjectName; String TargetObjectType; }; #pragma deleteclass( "DDL_PARTITION_FUNCTION_EVENTS", NOFAIL ) class DDL_PARTITION_FUNCTION_EVENTS : DDL_PARTITION_EVENTS { }; #pragma deleteclass( "DDL_QUEUE_EVENTS", NOFAIL ) class DDL_QUEUE_EVENTS : DDL_SSB_EVENTS { String SchemaName; }; #pragma deleteclass( "DDL_SCHEMA_EVENTS", NOFAIL ) class DDL_SCHEMA_EVENTS : DDL_DATABASE_SECURITY_EVENTS { String SchemaName; String TSQLCommand; }; #pragma deleteclass( "DDL_PARTITION_SCHEME_EVENTS", NOFAIL ) class DDL_PARTITION_SCHEME_EVENTS : DDL_PARTITION_EVENTS { String Function; }; #pragma deleteclass( "DDL_ROLE_EVENTS", NOFAIL ) class DDL_ROLE_EVENTS : DDL_DATABASE_SECURITY_EVENTS { String ObjectType; String ObjectName; String TSQLCommand; Uint8 SID[]; }; #pragma deleteclass( "DDL_CERTIFICATE_EVENTS", NOFAIL ) class DDL_CERTIFICATE_EVENTS : DDL_DATABASE_SECURITY_EVENTS { String ObjectType; String ObjectName; String OwnerName; }; #pragma deleteclass( "DDL_AUTHORIZATION_DATABASE_EVENTS", NOFAIL ) class DDL_AUTHORIZATION_DATABASE_EVENTS : DDL_DATABASE_SECURITY_EVENTS { }; #pragma deleteclass( "DDL_ROUTE_EVENTS", NOFAIL ) class DDL_ROUTE_EVENTS : DDL_SSB_EVENTS { }; #pragma deleteclass( "DDL_GDR_DATABASE_EVENTS", NOFAIL ) class DDL_GDR_DATABASE_EVENTS : DDL_DATABASE_SECURITY_EVENTS { String AsGrantor; String Grantor; String SchemaName; Boolean GrantOption; String Permissions; String ObjectType; String ObjectName; String TSQLCommand; String Grantees; Boolean CascadeOption; }; #pragma deleteclass( "DDL_SERVICE_EVENTS", NOFAIL ) class DDL_SERVICE_EVENTS : DDL_SSB_EVENTS { String TargetObjectName; String TargetSchemaName; String TargetObjectType; }; #pragma deleteclass( "DDL_APPLICATION_ROLE_EVENTS", NOFAIL ) class DDL_APPLICATION_ROLE_EVENTS : DDL_DATABASE_SECURITY_EVENTS { String DefaultSchema; String ObjectType; String ObjectName; Uint8 SID[]; }; #pragma deleteclass( "DDL_TABLE_EVENTS", NOFAIL ) class DDL_TABLE_EVENTS : DDL_TABLE_VIEW_EVENTS { String ObjectName; }; #pragma deleteclass( "DDL_USER_EVENTS", NOFAIL ) class DDL_USER_EVENTS : DDL_DATABASE_SECURITY_EVENTS { String DefaultSchema; String ObjectType; String ObjectName; String TSQLCommand; Uint8 SID[]; }; #pragma deleteclass( "DDL_MESSAGE_TYPE_EVENTS", NOFAIL ) class DDL_MESSAGE_TYPE_EVENTS : DDL_SSB_EVENTS { }; #pragma deleteclass( "ALTER_REMOTE_SERVICE_BINDING", NOFAIL ) class ALTER_REMOTE_SERVICE_BINDING : DDL_REMOTE_SERVICE_BINDING_EVENTS { }; #pragma deleteclass( "USERCONFIGURABLE_1", NOFAIL ) class USERCONFIGURABLE_1 : TRC_USER_CONFIGURABLE { }; #pragma deleteclass( "AUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT", NOFAIL ) class AUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; Sint64 Permissions; String OwnerName; }; #pragma deleteclass( "AUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT", NOFAIL ) class AUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; String RoleName; Sint32 ObjectType; Sint64 XactSequence; String OwnerName; }; #pragma deleteclass( "AUDIT_DATABASE_OBJECT_GDR_EVENT", NOFAIL ) class AUDIT_DATABASE_OBJECT_GDR_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String TargetUserName; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; Sint64 Permissions; String OwnerName; }; #pragma deleteclass( "EXCHANGE_SPILL_EVENT", NOFAIL ) class EXCHANGE_SPILL_EVENT : TRC_ERRORS_AND_WARNINGS { String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint32 ObjectID; Sint64 XactSequence; Sint32 EventSubClass; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "USER_ERROR_MESSAGE", NOFAIL ) class USER_ERROR_MESSAGE : TRC_ERRORS_AND_WARNINGS { String TextData; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint32 State; Sint32 Severity; Sint64 XactSequence; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; Sint32 Error; }; #pragma deleteclass( "DROP_ASSEMBLY", NOFAIL ) class DROP_ASSEMBLY : DDL_ASSEMBLY_EVENTS { }; #pragma deleteclass( "DROP_ROUTE", NOFAIL ) class DROP_ROUTE : DDL_ROUTE_EVENTS { }; #pragma deleteclass( "OLEDB_QUERYINTERFACE_EVENT", NOFAIL ) class OLEDB_QUERYINTERFACE_EVENT : TRC_OLEDB { String MethodName; Sint64 Duration; Sint32 EventSubClass; DateTime EndTime; Sint32 Error; }; #pragma deleteclass( "SERVER_MEMORY_CHANGE", NOFAIL ) class SERVER_MEMORY_CHANGE : TRC_SERVER { Sint64 TransactionID; Sint64 XactSequence; Sint32 EventSubClass; Sint32 IntegerData; Sint32 RequestID; }; #pragma deleteclass( "AUDIT_CHANGE_AUDIT_EVENT", NOFAIL ) class AUDIT_CHANGE_AUDIT_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint32 LineNumber; Sint32 ClientProcessID; Uint8 LoginSid[]; String DBUserName; Sint64 XactSequence; Sint32 EventSubClass; Sint32 ColumnPermissions; String OwnerName; }; #pragma deleteclass( "ALTER_QUEUE", NOFAIL ) class ALTER_QUEUE : DDL_QUEUE_EVENTS { }; #pragma deleteclass( "LOG_FILE_AUTO_GROW", NOFAIL ) class LOG_FILE_AUTO_GROW : TRC_DATABASE { String LoginName; String ApplicationName; Sint32 ClientProcessID; String NTDomainName; Sint64 Duration; String HostName; DateTime EndTime; String FileName; }; #pragma deleteclass( "ALTER_INDEX", NOFAIL ) class ALTER_INDEX : DDL_INDEX_EVENTS { }; #pragma deleteclass( "SHOWPLAN_XML", NOFAIL ) class SHOWPLAN_XML : TRC_PERFORMANCE { String TextData; }; #pragma deleteclass( "MISSING_JOIN_PREDICATE", NOFAIL ) class MISSING_JOIN_PREDICATE : TRC_ERRORS_AND_WARNINGS { String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint64 XactSequence; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "ALTER_AUTHORIZATION_SERVER", NOFAIL ) class ALTER_AUTHORIZATION_SERVER : DDL_AUTHORIZATION_SERVER_EVENTS { String ObjectType; String ObjectName; String TSQLCommand; String OwnerName; }; #pragma deleteclass( "EXCEPTION", NOFAIL ) class EXCEPTION : TRC_ERRORS_AND_WARNINGS { String TextData; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint32 State; Sint32 Severity; Sint64 XactSequence; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; Sint32 Error; }; #pragma deleteclass( "OLEDB_DATAREAD_EVENT", NOFAIL ) class OLEDB_DATAREAD_EVENT : TRC_OLEDB { String MethodName; Sint64 Duration; Sint32 EventSubClass; DateTime EndTime; Sint32 Error; }; #pragma deleteclass( "DEPRECATION_FINAL_SUPPORT", NOFAIL ) class DEPRECATION_FINAL_SUPPORT : TRC_DEPRECATION { }; #pragma deleteclass( "CREATE_APPLICATION_ROLE", NOFAIL ) class CREATE_APPLICATION_ROLE : DDL_APPLICATION_ROLE_EVENTS { }; #pragma deleteclass( "QUEUE_ACTIVATION", NOFAIL ) class QUEUE_ACTIVATION : ALL_EVENTS { String SchemaName; String DatabaseName; String ObjectType; String ObjectName; }; #pragma deleteclass( "DROP_SCHEMA", NOFAIL ) class DROP_SCHEMA : DDL_SCHEMA_EVENTS { String OwnerName; }; #pragma deleteclass( "DROP_XML_SCHEMA_COLLECTION", NOFAIL ) class DROP_XML_SCHEMA_COLLECTION : DDL_XML_SCHEMA_COLLECTION_EVENTS { }; #pragma deleteclass( "AUDIT_BACKUP_RESTORE_EVENT", NOFAIL ) class AUDIT_BACKUP_RESTORE_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Sint32 LineNumber; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "DENY_DATABASE", NOFAIL ) class DENY_DATABASE : DDL_GDR_DATABASE_EVENTS { }; #pragma deleteclass( "DROP_PROCEDURE", NOFAIL ) class DROP_PROCEDURE : DDL_PROCEDURE_EVENTS { }; #pragma deleteclass( "USERCONFIGURABLE_2", NOFAIL ) class USERCONFIGURABLE_2 : TRC_USER_CONFIGURABLE { }; #pragma deleteclass( "FT_CRAWL_STARTED", NOFAIL ) class FT_CRAWL_STARTED : TRC_FULL_TEXT { String TextData; }; #pragma deleteclass( "SP_CACHEMISS", NOFAIL ) class SP_CACHEMISS : TRC_STORED_PROCEDURES { String ObjectName; }; #pragma deleteclass( "CREATE_ROLE", NOFAIL ) class CREATE_ROLE : DDL_ROLE_EVENTS { }; #pragma deleteclass( "CREATE_PARTITION_FUNCTION", NOFAIL ) class CREATE_PARTITION_FUNCTION : DDL_PARTITION_FUNCTION_EVENTS { }; #pragma deleteclass( "DEPRECATION_ANNOUNCEMENT", NOFAIL ) class DEPRECATION_ANNOUNCEMENT : TRC_DEPRECATION { }; #pragma deleteclass( "AUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT", NOFAIL ) class AUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String TargetUserName; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; String ParentName; String OwnerName; }; #pragma deleteclass( "SP_CACHEREMOVE", NOFAIL ) class SP_CACHEREMOVE : TRC_STORED_PROCEDURES { String DatabaseName; Sint32 EventSubClass; }; #pragma deleteclass( "ALTER_USER", NOFAIL ) class ALTER_USER : DDL_USER_EVENTS { }; #pragma deleteclass( "CREATE_PARTITION_SCHEME", NOFAIL ) class CREATE_PARTITION_SCHEME : DDL_PARTITION_SCHEME_EVENTS { }; #pragma deleteclass( "CREATE_USER", NOFAIL ) class CREATE_USER : DDL_USER_EVENTS { }; #pragma deleteclass( "ALTER_ENDPOINT", NOFAIL ) class ALTER_ENDPOINT : DDL_ENDPOINT_EVENTS { }; #pragma deleteclass( "DROP_TRIGGER", NOFAIL ) class DROP_TRIGGER : DDL_TRIGGER_EVENTS { }; #pragma deleteclass( "DROP_EVENT_NOTIFICATION", NOFAIL ) class DROP_EVENT_NOTIFICATION : DDL_EVENT_NOTIFICATION_EVENTS { }; #pragma deleteclass( "BROKER_QUEUE_DISABLED", NOFAIL ) class BROKER_QUEUE_DISABLED : ALL_EVENTS { String SchemaName; String DatabaseName; String ObjectType; String ObjectName; }; #pragma deleteclass( "OLEDB_CALL_EVENT", NOFAIL ) class OLEDB_CALL_EVENT : TRC_OLEDB { String MethodName; Sint64 Duration; Sint32 EventSubClass; DateTime EndTime; Sint32 Error; }; #pragma deleteclass( "AUDIT_LOGOUT", NOFAIL ) class AUDIT_LOGOUT : TRC_SECURITY_AUDIT { Sint64 Reads; Sint32 ClientProcessID; Uint8 LoginSid[]; Sint32 CPU; Sint64 Writes; Sint64 Duration; DateTime EndTime; }; #pragma deleteclass( "AUDIT_CHANGE_DATABASE_OWNER", NOFAIL ) class AUDIT_CHANGE_DATABASE_OWNER : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String TargetUserName; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; String OwnerName; }; #pragma deleteclass( "DROP_SYNONYM", NOFAIL ) class DROP_SYNONYM : DDL_SYNONYM_EVENTS { }; #pragma deleteclass( "DROP_INDEX", NOFAIL ) class DROP_INDEX : DDL_INDEX_EVENTS { }; #pragma deleteclass( "XQUERY_STATIC_TYPE", NOFAIL ) class XQUERY_STATIC_TYPE : TRC_TSQL { String MethodName; }; #pragma deleteclass( "DROP_ENDPOINT", NOFAIL ) class DROP_ENDPOINT : DDL_ENDPOINT_EVENTS { }; #pragma deleteclass( "AUDIT_ADD_ROLE_EVENT", NOFAIL ) class AUDIT_ADD_ROLE_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; Sint64 TransactionID; Sint32 ClientProcessID; Uint8 LoginSid[]; String DBUserName; String RoleName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; }; #pragma deleteclass( "SHOWPLAN_XML_STATISTICS_PROFILE", NOFAIL ) class SHOWPLAN_XML_STATISTICS_PROFILE : TRC_PERFORMANCE { String TextData; }; #pragma deleteclass( "DROP_DATABASE", NOFAIL ) class DROP_DATABASE : DDL_SERVER_LEVEL_EVENTS { String DatabaseName; String TSQLCommand; }; #pragma deleteclass( "CREATE_TRIGGER", NOFAIL ) class CREATE_TRIGGER : DDL_TRIGGER_EVENTS { }; #pragma deleteclass( "AUDIT_SERVER_OPERATION_EVENT", NOFAIL ) class AUDIT_SERVER_OPERATION_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "ERRORLOG", NOFAIL ) class ERRORLOG : TRC_ERRORS_AND_WARNINGS { String TextData; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint32 Severity; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; Sint32 Error; }; #pragma deleteclass( "DATABASE_MIRRORING_STATE_CHANGE", NOFAIL ) class DATABASE_MIRRORING_STATE_CHANGE : TRC_DATABASE { String TextData; Sint64 TransactionID; Sint32 State; Sint32 RequestID; }; #pragma deleteclass( "QN__DYNAMICS", NOFAIL ) class QN__DYNAMICS : TRC_QUERY_NOTIFICATIONS { }; #pragma deleteclass( "DROP_FUNCTION", NOFAIL ) class DROP_FUNCTION : DDL_FUNCTION_EVENTS { }; #pragma deleteclass( "AUDIT_SCHEMA_OBJECT_GDR_EVENT", NOFAIL ) class AUDIT_SCHEMA_OBJECT_GDR_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String TargetUserName; Sint32 LineNumber; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; Sint32 ColumnPermissions; String ParentName; Sint64 Permissions; String OwnerName; }; #pragma deleteclass( "CREATE_EVENT_NOTIFICATION", NOFAIL ) class CREATE_EVENT_NOTIFICATION : DDL_EVENT_NOTIFICATION_EVENTS { }; #pragma deleteclass( "USERCONFIGURABLE_5", NOFAIL ) class USERCONFIGURABLE_5 : TRC_USER_CONFIGURABLE { }; #pragma deleteclass( "ALTER_PARTITION_FUNCTION", NOFAIL ) class ALTER_PARTITION_FUNCTION : DDL_PARTITION_FUNCTION_EVENTS { }; #pragma deleteclass( "OBJECT_CREATED", NOFAIL ) class OBJECT_CREATED : TRC_OBJECTS { }; #pragma deleteclass( "AUDIT_DATABASE_OPERATION_EVENT", NOFAIL ) class AUDIT_DATABASE_OPERATION_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "SORT_WARNINGS", NOFAIL ) class SORT_WARNINGS : TRC_ERRORS_AND_WARNINGS { String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint64 XactSequence; Sint32 EventSubClass; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "CREATE_FUNCTION", NOFAIL ) class CREATE_FUNCTION : DDL_FUNCTION_EVENTS { }; #pragma deleteclass( "DROP_PARTITION_FUNCTION", NOFAIL ) class DROP_PARTITION_FUNCTION : DDL_PARTITION_FUNCTION_EVENTS { }; #pragma deleteclass( "USERCONFIGURABLE_9", NOFAIL ) class USERCONFIGURABLE_9 : TRC_USER_CONFIGURABLE { }; #pragma deleteclass( "DROP_PARTITION_SCHEME", NOFAIL ) class DROP_PARTITION_SCHEME : DDL_PARTITION_SCHEME_EVENTS { }; #pragma deleteclass( "LOG_FILE_AUTO_SHRINK", NOFAIL ) class LOG_FILE_AUTO_SHRINK : TRC_DATABASE { String LoginName; String ApplicationName; Sint32 ClientProcessID; String NTDomainName; Sint64 Duration; String HostName; DateTime EndTime; String FileName; }; #pragma deleteclass( "AUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT", NOFAIL ) class AUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Uint8 LoginSid[]; String ObjectName; String DBUserName; String RoleName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; Sint64 Permissions; String OwnerName; }; #pragma deleteclass( "MISSING_COLUMN_STATISTICS", NOFAIL ) class MISSING_COLUMN_STATISTICS : TRC_ERRORS_AND_WARNINGS { String TextData; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint64 XactSequence; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "CREATE_TYPE", NOFAIL ) class CREATE_TYPE : DDL_TYPE_EVENTS { }; #pragma deleteclass( "ALTER_PARTITION_SCHEME", NOFAIL ) class ALTER_PARTITION_SCHEME : DDL_PARTITION_SCHEME_EVENTS { }; #pragma deleteclass( "CREATE_XML_INDEX", NOFAIL ) class CREATE_XML_INDEX : DDL_INDEX_EVENTS { String PrimaryXMLIndexName; String SecondaryXMLIndexType; }; #pragma deleteclass( "DROP_CERTIFICATE", NOFAIL ) class DROP_CERTIFICATE : DDL_CERTIFICATE_EVENTS { String TSQLCommand; }; #pragma deleteclass( "AUDIT_SCHEMA_OBJECT_ACCESS_EVENT", NOFAIL ) class AUDIT_SCHEMA_OBJECT_ACCESS_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Sint32 LineNumber; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; Sint32 ColumnPermissions; Uint8 BinaryData[]; String ParentName; Sint64 Permissions; String OwnerName; }; #pragma deleteclass( "CREATE_SCHEMA", NOFAIL ) class CREATE_SCHEMA : DDL_SCHEMA_EVENTS { String OwnerName; }; #pragma deleteclass( "ALTER_SERVICE", NOFAIL ) class ALTER_SERVICE : DDL_SERVICE_EVENTS { }; #pragma deleteclass( "ALTER_SCHEMA", NOFAIL ) class ALTER_SCHEMA : DDL_SCHEMA_EVENTS { String ObjectName; }; #pragma deleteclass( "ALTER_TRIGGER", NOFAIL ) class ALTER_TRIGGER : DDL_TRIGGER_EVENTS { }; #pragma deleteclass( "CREATE_MESSAGE_TYPE", NOFAIL ) class CREATE_MESSAGE_TYPE : DDL_MESSAGE_TYPE_EVENTS { }; #pragma deleteclass( "ALTER_TABLE", NOFAIL ) class ALTER_TABLE : DDL_TABLE_EVENTS { }; #pragma deleteclass( "FT_CRAWL_STOPPED", NOFAIL ) class FT_CRAWL_STOPPED : TRC_FULL_TEXT { }; #pragma deleteclass( "CREATE_QUEUE", NOFAIL ) class CREATE_QUEUE : DDL_QUEUE_EVENTS { }; #pragma deleteclass( "CREATE_PROCEDURE", NOFAIL ) class CREATE_PROCEDURE : DDL_PROCEDURE_EVENTS { }; #pragma deleteclass( "ALTER_VIEW", NOFAIL ) class ALTER_VIEW : DDL_VIEW_EVENTS { }; #pragma deleteclass( "AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT", NOFAIL ) class AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String TargetUserName; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "CREATE_INDEX", NOFAIL ) class CREATE_INDEX : DDL_INDEX_EVENTS { }; #pragma deleteclass( "DROP_SERVER_ROLE_MEMBER", NOFAIL ) class DROP_SERVER_ROLE_MEMBER : DDL_SERVER_SECURITY_EVENTS { String ObjectType; String ObjectName; String LoginType; Uint8 RoleSID[]; String RoleName; String DefaultDatabase; Uint8 SID[]; String DefaultLanguage; }; #pragma deleteclass( "TRACE_FILE_CLOSE", NOFAIL ) class TRACE_FILE_CLOSE : TRC_SERVER { String LoginName; Sint32 ObjectID; String FileName; }; #pragma deleteclass( "AUDIT_SERVER_ALTER_TRACE_EVENT", NOFAIL ) class AUDIT_SERVER_ALTER_TRACE_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; String OwnerName; }; #pragma deleteclass( "REVOKE_DATABASE", NOFAIL ) class REVOKE_DATABASE : DDL_GDR_DATABASE_EVENTS { }; #pragma deleteclass( "DROP_CONTRACT", NOFAIL ) class DROP_CONTRACT : DDL_CONTRACT_EVENTS { }; #pragma deleteclass( "DATA_FILE_AUTO_SHRINK", NOFAIL ) class DATA_FILE_AUTO_SHRINK : TRC_DATABASE { String LoginName; String ApplicationName; Sint32 ClientProcessID; String NTDomainName; Sint64 Duration; String HostName; DateTime EndTime; String FileName; }; #pragma deleteclass( "CREATE_TABLE", NOFAIL ) class CREATE_TABLE : DDL_TABLE_EVENTS { }; #pragma deleteclass( "DROP_APPLICATION_ROLE", NOFAIL ) class DROP_APPLICATION_ROLE : DDL_APPLICATION_ROLE_EVENTS { String TSQLCommand; }; #pragma deleteclass( "LOCK_DEADLOCK_CHAIN", NOFAIL ) class LOCK_DEADLOCK_CHAIN : TRC_LOCKS { String TextData; Sint32 Type; String DatabaseName; Sint32 ObjectID; Sint64 ObjectID2; Sint32 DatabaseID; Sint32 IntegerData2; Sint32 EventSubClass; Sint64 BigintData1; Uint8 BinaryData[]; Sint32 IntegerData; Sint32 RequestID; Sint32 Mode; Sint32 OwnerID; }; #pragma deleteclass( "ALTER_ROUTE", NOFAIL ) class ALTER_ROUTE : DDL_ROUTE_EVENTS { }; #pragma deleteclass( "AUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT", NOFAIL ) class AUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Sint32 LineNumber; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "QN__TEMPLATE", NOFAIL ) class QN__TEMPLATE : TRC_QUERY_NOTIFICATIONS { }; #pragma deleteclass( "DROP_TABLE", NOFAIL ) class DROP_TABLE : DDL_TABLE_EVENTS { }; #pragma deleteclass( "CREATE_DATABASE", NOFAIL ) class CREATE_DATABASE : DDL_SERVER_LEVEL_EVENTS { String DatabaseName; String TSQLCommand; }; #pragma deleteclass( "DROP_VIEW", NOFAIL ) class DROP_VIEW : DDL_VIEW_EVENTS { }; #pragma deleteclass( "ALTER_DATABASE", NOFAIL ) class ALTER_DATABASE : DDL_SERVER_LEVEL_EVENTS { String DatabaseName; String TSQLCommand; }; #pragma deleteclass( "ADD_SERVER_ROLE_MEMBER", NOFAIL ) class ADD_SERVER_ROLE_MEMBER : DDL_SERVER_SECURITY_EVENTS { String ObjectType; String ObjectName; String LoginType; Uint8 RoleSID[]; String RoleName; String DefaultDatabase; Uint8 SID[]; String DefaultLanguage; }; #pragma deleteclass( "SHOWPLAN_ALL_FOR_QUERY_COMPILE", NOFAIL ) class SHOWPLAN_ALL_FOR_QUERY_COMPILE : TRC_PERFORMANCE { String NTUserName; }; #pragma deleteclass( "DROP_QUEUE", NOFAIL ) class DROP_QUEUE : DDL_QUEUE_EVENTS { }; #pragma deleteclass( "AUDIT_LOGIN_CHANGE_PROPERTY_EVENT", NOFAIL ) class AUDIT_LOGIN_CHANGE_PROPERTY_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Sint32 LineNumber; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "AUDIT_DATABASE_OBJECT_ACCESS_EVENT", NOFAIL ) class AUDIT_DATABASE_OBJECT_ACCESS_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; Sint64 Permissions; String OwnerName; }; #pragma deleteclass( "DROP_MESSAGE_TYPE", NOFAIL ) class DROP_MESSAGE_TYPE : DDL_MESSAGE_TYPE_EVENTS { }; #pragma deleteclass( "AUDIT_DATABASE_MANAGEMENT_EVENT", NOFAIL ) class AUDIT_DATABASE_MANAGEMENT_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "QN__SUBSCRIPTION", NOFAIL ) class QN__SUBSCRIPTION : TRC_QUERY_NOTIFICATIONS { }; #pragma deleteclass( "CREATE_SYNONYM", NOFAIL ) class CREATE_SYNONYM : DDL_SYNONYM_EVENTS { }; #pragma deleteclass( "AUDIT_LOGIN_GDR_EVENT", NOFAIL ) class AUDIT_LOGIN_GDR_EVENT : TRC_SECURITY_AUDIT { Sint64 TransactionID; Sint32 ClientProcessID; Uint8 LoginSid[]; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; }; #pragma deleteclass( "CREATE_ENDPOINT", NOFAIL ) class CREATE_ENDPOINT : DDL_ENDPOINT_EVENTS { }; #pragma deleteclass( "CREATE_XML_SCHEMA_COLLECTION", NOFAIL ) class CREATE_XML_SCHEMA_COLLECTION : DDL_XML_SCHEMA_COLLECTION_EVENTS { }; #pragma deleteclass( "ALTER_CERTIFICATE", NOFAIL ) class ALTER_CERTIFICATE : DDL_CERTIFICATE_EVENTS { String PrivateKeyPath; }; #pragma deleteclass( "AUDIT_LOGIN_FAILED", NOFAIL ) class AUDIT_LOGIN_FAILED : TRC_SECURITY_AUDIT { String TextData; Sint32 ClientProcessID; Sint32 Error; }; #pragma deleteclass( "AUDIT_LOGIN", NOFAIL ) class AUDIT_LOGIN : TRC_SECURITY_AUDIT { String TextData; Sint32 ClientProcessID; Uint8 LoginSid[]; Uint8 BinaryData[]; Sint32 IntegerData; }; #pragma deleteclass( "LOCK_DEADLOCK", NOFAIL ) class LOCK_DEADLOCK : TRC_LOCKS { String TextData; Sint32 Type; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint32 ObjectID; Sint64 ObjectID2; Sint32 DatabaseID; Sint64 Duration; Sint32 IntegerData2; String HostName; DateTime EndTime; Sint64 BigintData1; String NTUserName; Uint8 BinaryData[]; Sint32 IntegerData; Sint32 RequestID; Sint32 Mode; Sint32 OwnerID; }; #pragma deleteclass( "OBJECT_DELETED", NOFAIL ) class OBJECT_DELETED : TRC_OBJECTS { }; #pragma deleteclass( "AUDIT_LOGIN_CHANGE_PASSWORD_EVENT", NOFAIL ) class AUDIT_LOGIN_CHANGE_PASSWORD_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "AUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT", NOFAIL ) class AUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String TargetUserName; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; String OwnerName; }; #pragma deleteclass( "FT_CRAWL_ABORTED", NOFAIL ) class FT_CRAWL_ABORTED : TRC_FULL_TEXT { Sint32 State; Sint32 Error; }; #pragma deleteclass( "AUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT", NOFAIL ) class AUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String TargetUserName; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; String OwnerName; }; #pragma deleteclass( "DATA_FILE_AUTO_GROW", NOFAIL ) class DATA_FILE_AUTO_GROW : TRC_DATABASE { String LoginName; String ApplicationName; Sint32 ClientProcessID; String NTDomainName; Sint64 Duration; String HostName; DateTime EndTime; String FileName; }; #pragma deleteclass( "ALTER_APPLICATION_ROLE", NOFAIL ) class ALTER_APPLICATION_ROLE : DDL_APPLICATION_ROLE_EVENTS { }; #pragma deleteclass( "ALTER_FUNCTION", NOFAIL ) class ALTER_FUNCTION : DDL_FUNCTION_EVENTS { }; #pragma deleteclass( "CREATE_STATISTICS", NOFAIL ) class CREATE_STATISTICS : DDL_STATISTICS_EVENTS { String ObjectName; }; #pragma deleteclass( "AUDIT_ADDLOGIN_EVENT", NOFAIL ) class AUDIT_ADDLOGIN_EVENT : TRC_SECURITY_AUDIT { Sint64 TransactionID; Sint32 LineNumber; Sint32 ClientProcessID; Uint8 LoginSid[]; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; }; #pragma deleteclass( "USERCONFIGURABLE_6", NOFAIL ) class USERCONFIGURABLE_6 : TRC_USER_CONFIGURABLE { }; #pragma deleteclass( "EVENTLOG", NOFAIL ) class EVENTLOG : TRC_ERRORS_AND_WARNINGS { String TextData; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint32 Severity; String HostName; String NTUserName; Uint8 BinaryData[]; Sint32 RequestID; DateTime StartTime; Sint32 Error; }; #pragma deleteclass( "USERCONFIGURABLE_0", NOFAIL ) class USERCONFIGURABLE_0 : TRC_USER_CONFIGURABLE { }; #pragma deleteclass( "USERCONFIGURABLE_7", NOFAIL ) class USERCONFIGURABLE_7 : TRC_USER_CONFIGURABLE { }; #pragma deleteclass( "SP_CACHEINSERT", NOFAIL ) class SP_CACHEINSERT : TRC_STORED_PROCEDURES { String DatabaseName; }; #pragma deleteclass( "USERCONFIGURABLE_8", NOFAIL ) class USERCONFIGURABLE_8 : TRC_USER_CONFIGURABLE { }; #pragma deleteclass( "DEADLOCK_GRAPH", NOFAIL ) class DEADLOCK_GRAPH : TRC_LOCKS { String TextData; String LoginName; }; #pragma deleteclass( "AUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT", NOFAIL ) class AUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String TargetUserName; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; String RoleName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "AUDIT_DBCC_EVENT", NOFAIL ) class AUDIT_DBCC_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Sint32 LineNumber; Sint32 ClientProcessID; Uint8 LoginSid[]; String DBUserName; Sint64 XactSequence; Sint32 ColumnPermissions; String OwnerName; }; #pragma deleteclass( "MOUNT_TAPE", NOFAIL ) class MOUNT_TAPE : TRC_SERVER { String TextData; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint32 DatabaseID; Sint64 Duration; Sint32 EventSubClass; String HostName; DateTime EndTime; String NTUserName; }; #pragma deleteclass( "ALTER_PROCEDURE", NOFAIL ) class ALTER_PROCEDURE : DDL_PROCEDURE_EVENTS { }; #pragma deleteclass( "USERCONFIGURABLE_3", NOFAIL ) class USERCONFIGURABLE_3 : TRC_USER_CONFIGURABLE { }; #pragma deleteclass( "GRANT_DATABASE", NOFAIL ) class GRANT_DATABASE : DDL_GDR_DATABASE_EVENTS { }; #pragma deleteclass( "ALTER_ROLE", NOFAIL ) class ALTER_ROLE : DDL_ROLE_EVENTS { }; #pragma deleteclass( "AUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT", NOFAIL ) class AUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; String RoleName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "DROP_USER", NOFAIL ) class DROP_USER : DDL_USER_EVENTS { }; #pragma deleteclass( "CREATE_ASSEMBLY", NOFAIL ) class CREATE_ASSEMBLY : DDL_ASSEMBLY_EVENTS { }; #pragma deleteclass( "LOCK_ESCALATION", NOFAIL ) class LOCK_ESCALATION : TRC_LOCKS { Sint32 Type; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint32 ObjectID; Sint64 ObjectID2; Sint32 DatabaseID; Sint32 IntegerData2; String HostName; String NTUserName; Sint32 RequestID; Sint32 Mode; Sint32 OwnerID; }; #pragma deleteclass( "ALTER_XML_SCHEMA_COLLECTION", NOFAIL ) class ALTER_XML_SCHEMA_COLLECTION : DDL_XML_SCHEMA_COLLECTION_EVENTS { }; #pragma deleteclass( "DROP_SERVICE", NOFAIL ) class DROP_SERVICE : DDL_SERVICE_EVENTS { }; #pragma deleteclass( "REVOKE_SERVER", NOFAIL ) class REVOKE_SERVER : DDL_GDR_SERVER_EVENTS { }; #pragma deleteclass( "DROP_STATISTICS", NOFAIL ) class DROP_STATISTICS : DDL_STATISTICS_EVENTS { String ObjectName; }; #pragma deleteclass( "DROP_LOGIN", NOFAIL ) class DROP_LOGIN : DDL_LOGIN_EVENTS { String TSQLCommand; }; #pragma deleteclass( "CREATE_CERTIFICATE", NOFAIL ) class CREATE_CERTIFICATE : DDL_CERTIFICATE_EVENTS { String CertificateSubject; String PrivateKeyPath; String CertificatePath; }; #pragma deleteclass( "DENY_SERVER", NOFAIL ) class DENY_SERVER : DDL_GDR_SERVER_EVENTS { }; #pragma deleteclass( "EXECUTION_WARNINGS", NOFAIL ) class EXECUTION_WARNINGS : TRC_ERRORS_AND_WARNINGS { String TextData; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint64 Duration; Sint64 XactSequence; Sint32 EventSubClass; String HostName; String NTUserName; Sint32 RequestID; DateTime StartTime; Sint32 Error; }; #pragma deleteclass( "SHOWPLAN_XML_FOR_QUERY_COMPILE", NOFAIL ) class SHOWPLAN_XML_FOR_QUERY_COMPILE : TRC_PERFORMANCE { String TextData; String NTUserName; }; #pragma deleteclass( "CREATE_LOGIN", NOFAIL ) class CREATE_LOGIN : DDL_LOGIN_EVENTS { }; #pragma deleteclass( "DROP_TYPE", NOFAIL ) class DROP_TYPE : DDL_TYPE_EVENTS { }; #pragma deleteclass( "OLEDB_PROVIDER_INFORMATION", NOFAIL ) class OLEDB_PROVIDER_INFORMATION : TRC_OLEDB { }; #pragma deleteclass( "DROP_REMOTE_SERVICE_BINDING", NOFAIL ) class DROP_REMOTE_SERVICE_BINDING : DDL_REMOTE_SERVICE_BINDING_EVENTS { }; #pragma deleteclass( "DROP_ROLE", NOFAIL ) class DROP_ROLE : DDL_ROLE_EVENTS { }; #pragma deleteclass( "AUDIT_SERVER_OBJECT_MANAGEMENT_EVENT", NOFAIL ) class AUDIT_SERVER_OBJECT_MANAGEMENT_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String LinkedServerName; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; String ProviderName; String OwnerName; }; #pragma deleteclass( "ALTER_LOGIN", NOFAIL ) class ALTER_LOGIN : DDL_LOGIN_EVENTS { }; #pragma deleteclass( "ADD_ROLE_MEMBER", NOFAIL ) class ADD_ROLE_MEMBER : DDL_SERVER_SECURITY_EVENTS { String DefaultSchema; String UserName; String DatabaseName; String ObjectType; String ObjectName; String RoleName; Uint8 SID[]; }; #pragma deleteclass( "HASH_WARNING", NOFAIL ) class HASH_WARNING : TRC_ERRORS_AND_WARNINGS { String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; String NTDomainName; Sint32 ObjectID; Sint64 XactSequence; Sint32 EventSubClass; String HostName; String NTUserName; Sint32 IntegerData; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "SP_RECOMPILE", NOFAIL ) class SP_RECOMPILE : TRC_STORED_PROCEDURES { Sint32 Offset; Sint32 NestLevel; Sint32 LineNumber; Uint8 SqlHandle[]; String DatabaseName; String ObjectName; Sint32 IntegerData2; Sint32 EventSubClass; }; #pragma deleteclass( "AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT", NOFAIL ) class AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Sint32 ObjectType; Sint64 XactSequence; Sint32 EventSubClass; String ParentName; String OwnerName; }; #pragma deleteclass( "DROP_ROLE_MEMBER", NOFAIL ) class DROP_ROLE_MEMBER : DDL_SERVER_SECURITY_EVENTS { String DefaultSchema; String UserName; String DatabaseName; String ObjectType; String ObjectName; String RoleName; Uint8 SID[]; }; #pragma deleteclass( "CREATE_REMOTE_SERVICE_BINDING", NOFAIL ) class CREATE_REMOTE_SERVICE_BINDING : DDL_REMOTE_SERVICE_BINDING_EVENTS { }; #pragma deleteclass( "AUDIT_SERVER_OBJECT_GDR_EVENT", NOFAIL ) class AUDIT_SERVER_OBJECT_GDR_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; Sint64 Permissions; String OwnerName; }; #pragma deleteclass( "ALTER_ASSEMBLY", NOFAIL ) class ALTER_ASSEMBLY : DDL_ASSEMBLY_EVENTS { }; #pragma deleteclass( "QN__PARAMETER_TABLE", NOFAIL ) class QN__PARAMETER_TABLE : TRC_QUERY_NOTIFICATIONS { }; #pragma deleteclass( "ASSEMBLY_LOAD", NOFAIL ) class ASSEMBLY_LOAD : TRC_CLR { String TextData; String LoginName; String ApplicationName; Sint32 ClientProcessID; String DatabaseName; Uint8 LoginSid[]; String NTDomainName; Sint32 ObjectID; String ObjectName; Sint32 Success; Sint32 DatabaseID; String HostName; String NTUserName; Sint32 IntegerData; Sint32 RequestID; DateTime StartTime; }; #pragma deleteclass( "AUDIT_DATABASE_SCOPE_GDR_EVENT", NOFAIL ) class AUDIT_DATABASE_SCOPE_GDR_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String TargetUserName; Sint32 LineNumber; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; Sint64 Permissions; String OwnerName; }; #pragma deleteclass( "CREATE_SERVICE", NOFAIL ) class CREATE_SERVICE : DDL_SERVICE_EVENTS { }; #pragma deleteclass( "GRANT_SERVER", NOFAIL ) class GRANT_SERVER : DDL_GDR_SERVER_EVENTS { }; #pragma deleteclass( "AUDIT_ADD_DB_USER_EVENT", NOFAIL ) class AUDIT_ADD_DB_USER_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; Sint64 TransactionID; String TargetUserName; Sint32 ClientProcessID; Uint8 LoginSid[]; String DBUserName; String RoleName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; Sint32 ColumnPermissions; String OwnerName; }; #pragma deleteclass( "AUDIT_SERVER_SCOPE_GDR_EVENT", NOFAIL ) class AUDIT_SERVER_SCOPE_GDR_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; Sint64 Permissions; String OwnerName; }; #pragma deleteclass( "ALTER_MESSAGE_TYPE", NOFAIL ) class ALTER_MESSAGE_TYPE : DDL_MESSAGE_TYPE_EVENTS { }; #pragma deleteclass( "CREATE_ROUTE", NOFAIL ) class CREATE_ROUTE : DDL_ROUTE_EVENTS { }; #pragma deleteclass( "OLEDB_ERRORS", NOFAIL ) class OLEDB_ERRORS : TRC_OLEDB { String MethodName; Sint32 Error; }; #pragma deleteclass( "USERCONFIGURABLE_4", NOFAIL ) class USERCONFIGURABLE_4 : TRC_USER_CONFIGURABLE { }; #pragma deleteclass( "UPDATE_STATISTICS", NOFAIL ) class UPDATE_STATISTICS : DDL_STATISTICS_EVENTS { }; #pragma deleteclass( "CREATE_VIEW", NOFAIL ) class CREATE_VIEW : DDL_VIEW_EVENTS { }; #pragma deleteclass( "OBJECT_ALTERED", NOFAIL ) class OBJECT_ALTERED : TRC_OBJECTS { }; #pragma deleteclass( "SQL_STMTRECOMPILE", NOFAIL ) class SQL_STMTRECOMPILE : TRC_TSQL { Sint32 Offset; Sint32 NestLevel; Uint8 SqlHandle[]; Sint32 ObjectID; String ObjectName; Sint32 IntegerData2; Sint32 ObjectType; Sint32 EventSubClass; }; #pragma deleteclass( "ALTER_AUTHORIZATION_DATABASE", NOFAIL ) class ALTER_AUTHORIZATION_DATABASE : DDL_AUTHORIZATION_DATABASE_EVENTS { String SchemaName; String ObjectType; String ObjectName; String TSQLCommand; String OwnerName; }; #pragma deleteclass( "CREATE_CONTRACT", NOFAIL ) class CREATE_CONTRACT : DDL_CONTRACT_EVENTS { }; #pragma deleteclass( "AUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT", NOFAIL ) class AUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT : TRC_SECURITY_AUDIT { Sint32 NestLevel; String TextData; Sint64 TransactionID; String LinkedServerName; String TargetUserName; Sint32 LineNumber; Sint32 ClientProcessID; Uint8 LoginSid[]; String ObjectName; String DBUserName; Uint8 TargetLoginSid[]; Sint32 ObjectType; Sint64 XactSequence; String TargetLoginName; Sint32 EventSubClass; String OwnerName; }; #pragma deleteclass( "BLOCKED_PROCESS_REPORT", NOFAIL ) class BLOCKED_PROCESS_REPORT : TRC_ERRORS_AND_WARNINGS { String TextData; Sint32 IndexID; Sint32 ObjectID; Sint64 Duration; DateTime EndTime; Sint32 Mode; }; //-------------------------------------------- // An instance of the __Win32Provider class to // describe the physical implementation of the // provider. //-------------------------------------------- instance of __Win32Provider as $SQLEventProv { // Name is the key property for __Provider objects. // vendor|provider|version is the suggested format // to prevent name collisions. // Name = "SQLServerEventProvider"; // Provider GUID // CLSID = "{7e71d286-9fe4-41c5-8a6f-b52d596a1a73}"; DefaultMachineName = NULL; // NULL for local machine ClientLoadableCLSID = NULL; // Reserved // Setting ImpersonationLevel to 1 indicates that the provider will // use impersonation calls to check operations performed on behalf // of the client. // ImpersonationLevel = 1; // Set of flags that provide information about serialization: // 0 = all initialization of this provider must be serialized // 1 = all initializations of this provider in the same namespace must be serialized // 2 = no initialization serialization is necessary // InitializationReentrancy = 0; // Request to be fully initialized as "Admin" before // initializations begin for users // InitializeAsAdminFirst = FALSE; // Indicates whether the provider is initialized for each // locale if a user connects to the same namespace more // than once using different locales. // PerLocaleInitialization = FALSE; // Indicates whether the provider is initialized once for each actual // Windows NT/Windows 2000 NTLM user making requests of the provider. // If set to FALSE, the provider is initialized once for all users // PerUserInitialization = FALSE; // A pure provider exists only to service requests from // applications and WMI. Most providers are pure providers // Non-pure providers transition to the role of client after they have // finished servicing requests. // Pure = TRUE; // Currently ignored // Use __CacheControl class in the root namespace to control provider unloading // A string in the DMTF date/time format that specifies how long WMI // allows the provider to remain idle before it is unloaded. // UnloadTimeout = NULL; }; //----------------------------------------------- // An instance of the __EventProviderRegistration // class to describe the logical implementation // of the provider. //----------------------------------------------- instance of __EventProviderRegistration { // Specifies the object path to the event provider. // provider = $SQLEventProv; // One or more WQL queries that describe the events that // the event provider supports. // EventQueryList = { "select * from DDL_EVENTS", "select * from TRC_ALL_EVENTS", "select * from DDL_DATABASE_LEVEL_EVENTS", "select * from TRC_USER_CONFIGURABLE", "select * from TRC_OBJECTS", "select * from DDL_SERVER_LEVEL_EVENTS", "select * from TRC_ERRORS_AND_WARNINGS", "select * from TRC_DEPRECATION", "select * from TRC_QUERY_NOTIFICATIONS", "select * from TRC_DATABASE", "select * from TRC_OLEDB", "select * from TRC_STORED_PROCEDURES", "select * from TRC_TSQL", "select * from TRC_FULL_TEXT", "select * from TRC_SECURITY_AUDIT", "select * from TRC_SERVER", "select * from TRC_PERFORMANCE", "select * from TRC_CLR", "select * from TRC_LOCKS", "select * from DDL_TRIGGER_EVENTS", "select * from DDL_FUNCTION_EVENTS", "select * from DDL_ENDPOINT_EVENTS", "select * from DDL_SYNONYM_EVENTS", "select * from DDL_SSB_EVENTS", "select * from DDL_DATABASE_SECURITY_EVENTS", "select * from DDL_EVENT_NOTIFICATION_EVENTS", "select * from DDL_PROCEDURE_EVENTS", "select * from DDL_SERVER_SECURITY_EVENTS", "select * from DDL_TABLE_VIEW_EVENTS", "select * from DDL_TYPE_EVENTS", "select * from DDL_XML_SCHEMA_COLLECTION_EVENTS", "select * from DDL_PARTITION_EVENTS", "select * from DDL_ASSEMBLY_EVENTS", "select * from DDL_LOGIN_EVENTS", "select * from DDL_STATISTICS_EVENTS", "select * from DDL_GDR_SERVER_EVENTS", "select * from DDL_VIEW_EVENTS", "select * from DDL_AUTHORIZATION_SERVER_EVENTS", "select * from DDL_REMOTE_SERVICE_BINDING_EVENTS", "select * from DDL_CONTRACT_EVENTS", "select * from DDL_INDEX_EVENTS", "select * from DDL_PARTITION_FUNCTION_EVENTS", "select * from DDL_QUEUE_EVENTS", "select * from DDL_SCHEMA_EVENTS", "select * from DDL_PARTITION_SCHEME_EVENTS", "select * from DDL_ROLE_EVENTS", "select * from DDL_CERTIFICATE_EVENTS", "select * from DDL_AUTHORIZATION_DATABASE_EVENTS", "select * from DDL_ROUTE_EVENTS", "select * from DDL_GDR_DATABASE_EVENTS", "select * from DDL_SERVICE_EVENTS", "select * from DDL_APPLICATION_ROLE_EVENTS", "select * from DDL_TABLE_EVENTS", "select * from DDL_USER_EVENTS", "select * from DDL_MESSAGE_TYPE_EVENTS", "select * from ALTER_REMOTE_SERVICE_BINDING", "select * from USERCONFIGURABLE_1", "select * from AUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT", "select * from AUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT", "select * from AUDIT_DATABASE_OBJECT_GDR_EVENT", "select * from EXCHANGE_SPILL_EVENT", "select * from USER_ERROR_MESSAGE", "select * from DROP_ASSEMBLY", "select * from DROP_ROUTE", "select * from OLEDB_QUERYINTERFACE_EVENT", "select * from SERVER_MEMORY_CHANGE", "select * from AUDIT_CHANGE_AUDIT_EVENT", "select * from ALTER_QUEUE", "select * from LOG_FILE_AUTO_GROW", "select * from ALTER_INDEX", "select * from SHOWPLAN_XML", "select * from MISSING_JOIN_PREDICATE", "select * from ALTER_AUTHORIZATION_SERVER", "select * from EXCEPTION", "select * from OLEDB_DATAREAD_EVENT", "select * from DEPRECATION_FINAL_SUPPORT", "select * from CREATE_APPLICATION_ROLE", "select * from QUEUE_ACTIVATION", "select * from DROP_SCHEMA", "select * from DROP_XML_SCHEMA_COLLECTION", "select * from AUDIT_BACKUP_RESTORE_EVENT", "select * from DENY_DATABASE", "select * from DROP_PROCEDURE", "select * from USERCONFIGURABLE_2", "select * from FT_CRAWL_STARTED", "select * from SP_CACHEMISS", "select * from CREATE_ROLE", "select * from CREATE_PARTITION_FUNCTION", "select * from DEPRECATION_ANNOUNCEMENT", "select * from AUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT", "select * from SP_CACHEREMOVE", "select * from ALTER_USER", "select * from CREATE_PARTITION_SCHEME", "select * from CREATE_USER", "select * from ALTER_ENDPOINT", "select * from DROP_TRIGGER", "select * from DROP_EVENT_NOTIFICATION", "select * from BROKER_QUEUE_DISABLED", "select * from OLEDB_CALL_EVENT", "select * from AUDIT_LOGOUT", "select * from AUDIT_CHANGE_DATABASE_OWNER", "select * from DROP_SYNONYM", "select * from DROP_INDEX", "select * from XQUERY_STATIC_TYPE", "select * from DROP_ENDPOINT", "select * from AUDIT_ADD_ROLE_EVENT", "select * from SHOWPLAN_XML_STATISTICS_PROFILE", "select * from DROP_DATABASE", "select * from CREATE_TRIGGER", "select * from AUDIT_SERVER_OPERATION_EVENT", "select * from ERRORLOG", "select * from DATABASE_MIRRORING_STATE_CHANGE", "select * from QN__DYNAMICS", "select * from DROP_FUNCTION", "select * from AUDIT_SCHEMA_OBJECT_GDR_EVENT", "select * from CREATE_EVENT_NOTIFICATION", "select * from USERCONFIGURABLE_5", "select * from ALTER_PARTITION_FUNCTION", "select * from OBJECT_CREATED", "select * from AUDIT_DATABASE_OPERATION_EVENT", "select * from SORT_WARNINGS", "select * from CREATE_FUNCTION", "select * from DROP_PARTITION_FUNCTION", "select * from USERCONFIGURABLE_9", "select * from DROP_PARTITION_SCHEME", "select * from LOG_FILE_AUTO_SHRINK", "select * from AUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT", "select * from MISSING_COLUMN_STATISTICS", "select * from CREATE_TYPE", "select * from ALTER_PARTITION_SCHEME", "select * from CREATE_XML_INDEX", "select * from DROP_CERTIFICATE", "select * from AUDIT_SCHEMA_OBJECT_ACCESS_EVENT", "select * from CREATE_SCHEMA", "select * from ALTER_SERVICE", "select * from ALTER_SCHEMA", "select * from ALTER_TRIGGER", "select * from CREATE_MESSAGE_TYPE", "select * from ALTER_TABLE", "select * from FT_CRAWL_STOPPED", "select * from CREATE_QUEUE", "select * from CREATE_PROCEDURE", "select * from ALTER_VIEW", "select * from AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT", "select * from CREATE_INDEX", "select * from DROP_SERVER_ROLE_MEMBER", "select * from TRACE_FILE_CLOSE", "select * from AUDIT_SERVER_ALTER_TRACE_EVENT", "select * from REVOKE_DATABASE", "select * from DROP_CONTRACT", "select * from DATA_FILE_AUTO_SHRINK", "select * from CREATE_TABLE", "select * from DROP_APPLICATION_ROLE", "select * from LOCK_DEADLOCK_CHAIN", "select * from ALTER_ROUTE", "select * from AUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT", "select * from QN__TEMPLATE", "select * from DROP_TABLE", "select * from CREATE_DATABASE", "select * from DROP_VIEW", "select * from ALTER_DATABASE", "select * from ADD_SERVER_ROLE_MEMBER", "select * from SHOWPLAN_ALL_FOR_QUERY_COMPILE", "select * from DROP_QUEUE", "select * from AUDIT_LOGIN_CHANGE_PROPERTY_EVENT", "select * from AUDIT_DATABASE_OBJECT_ACCESS_EVENT", "select * from DROP_MESSAGE_TYPE", "select * from AUDIT_DATABASE_MANAGEMENT_EVENT", "select * from QN__SUBSCRIPTION", "select * from CREATE_SYNONYM", "select * from AUDIT_LOGIN_GDR_EVENT", "select * from CREATE_ENDPOINT", "select * from CREATE_XML_SCHEMA_COLLECTION", "select * from ALTER_CERTIFICATE", "select * from AUDIT_LOGIN_FAILED", "select * from AUDIT_LOGIN", "select * from LOCK_DEADLOCK", "select * from OBJECT_DELETED", "select * from AUDIT_LOGIN_CHANGE_PASSWORD_EVENT", "select * from AUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT", "select * from FT_CRAWL_ABORTED", "select * from AUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT", "select * from DATA_FILE_AUTO_GROW", "select * from ALTER_APPLICATION_ROLE", "select * from ALTER_FUNCTION", "select * from CREATE_STATISTICS", "select * from AUDIT_ADDLOGIN_EVENT", "select * from USERCONFIGURABLE_6", "select * from EVENTLOG", "select * from USERCONFIGURABLE_0", "select * from USERCONFIGURABLE_7", "select * from SP_CACHEINSERT", "select * from USERCONFIGURABLE_8", "select * from DEADLOCK_GRAPH", "select * from AUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT", "select * from AUDIT_DBCC_EVENT", "select * from MOUNT_TAPE", "select * from ALTER_PROCEDURE", "select * from USERCONFIGURABLE_3", "select * from GRANT_DATABASE", "select * from ALTER_ROLE", "select * from AUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT", "select * from DROP_USER", "select * from CREATE_ASSEMBLY", "select * from LOCK_ESCALATION", "select * from ALTER_XML_SCHEMA_COLLECTION", "select * from DROP_SERVICE", "select * from REVOKE_SERVER", "select * from DROP_STATISTICS", "select * from DROP_LOGIN", "select * from CREATE_CERTIFICATE", "select * from DENY_SERVER", "select * from EXECUTION_WARNINGS", "select * from SHOWPLAN_XML_FOR_QUERY_COMPILE", "select * from CREATE_LOGIN", "select * from DROP_TYPE", "select * from OLEDB_PROVIDER_INFORMATION", "select * from DROP_REMOTE_SERVICE_BINDING", "select * from DROP_ROLE", "select * from AUDIT_SERVER_OBJECT_MANAGEMENT_EVENT", "select * from ALTER_LOGIN", "select * from ADD_ROLE_MEMBER", "select * from HASH_WARNING", "select * from SP_RECOMPILE", "select * from AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT", "select * from DROP_ROLE_MEMBER", "select * from CREATE_REMOTE_SERVICE_BINDING", "select * from AUDIT_SERVER_OBJECT_GDR_EVENT", "select * from ALTER_ASSEMBLY", "select * from QN__PARAMETER_TABLE", "select * from ASSEMBLY_LOAD", "select * from AUDIT_DATABASE_SCOPE_GDR_EVENT", "select * from CREATE_SERVICE", "select * from GRANT_SERVER", "select * from AUDIT_ADD_DB_USER_EVENT", "select * from AUDIT_SERVER_SCOPE_GDR_EVENT", "select * from ALTER_MESSAGE_TYPE", "select * from CREATE_ROUTE", "select * from OLEDB_ERRORS", "select * from USERCONFIGURABLE_4", "select * from UPDATE_STATISTICS", "select * from CREATE_VIEW", "select * from OBJECT_ALTERED", "select * from SQL_STMTRECOMPILE", "select * from ALTER_AUTHORIZATION_DATABASE", "select * from CREATE_CONTRACT", "select * from AUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT", "select * from BLOCKED_PROCESS_REPORT" }; };