__EventProviderRegistration, ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER - Instances

Class | Methods | Properties (2) | Qualifiers | Instances (1) | Namespaces (142)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Instances of __EventProviderRegistration

This section contains sample wmi instances of __EventProviderRegistration class with their properties from Microsoft Windows Server 2012 R2 Datacenter Evaluation.

Instance \\W2012SDC\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:__EventProviderRegistration.provider="\\\\.\\root\\Microsoft\\SqlServer\\ServerEvents\\MSSQLSERVER:__Win32Provider.Name=\"SQLServerEventProvider\""

Properties={
   'EventQueryList' : ['select * from ADD_ROLE_MEMBER', 'select * from ADD_SERVER_ROLE_MEMBER', 'select * from ADD_SIGNATURE', 'select * from ADD_SIGNATURE_SCHEMA_OBJECT', 'select * from ALTER_APPLICATION_ROLE', 'select * from ALTER_ASSEMBLY', 'select * from ALTER_ASYMMETRIC_KEY', 'select * from ALTER_AUDIT', 'select * from ALTER_AUTHORIZATION_DATABASE', 'select * from ALTER_AUTHORIZATION_SERVER', 'select * from ALTER_AVAILABILITY_GROUP', 'select * from ALTER_BROKER_PRIORITY', 'select * from ALTER_CERTIFICATE', 'select * from ALTER_CREDENTIAL', 'select * from ALTER_CRYPTOGRAPHIC_PROVIDER', 'select * from ALTER_DATABASE', 'select * from ALTER_DATABASE_AUDIT_SPECIFICATION', 'select * from ALTER_DATABASE_ENCRYPTION_KEY', 'select * from ALTER_ENDPOINT', 'select * from ALTER_EVENT_SESSION', 'select * from ALTER_EXTENDED_PROPERTY', 'select * from ALTER_FULLTEXT_CATALOG', 'select * from ALTER_FULLTEXT_INDEX', 'select * from ALTER_FULLTEXT_STOPLIST', 'select * from ALTER_FUNCTION', 'select * from ALTER_INDEX', 'select * from ALTER_INSTANCE', 'select * from ALTER_LINKED_SERVER', 'select * from ALTER_LOGIN', 'select * from ALTER_MASTER_KEY', 'select * from ALTER_MESSAGE', 'select * from ALTER_MESSAGE_TYPE', 'select * from ALTER_PARTITION_FUNCTION', 'select * from ALTER_PARTITION_SCHEME', 'select * from ALTER_PLAN_GUIDE', 'select * from ALTER_PROCEDURE', 'select * from ALTER_QUEUE', 'select * from ALTER_REMOTE_SERVER', 'select * from ALTER_REMOTE_SERVICE_BINDING', 'select * from ALTER_RESOURCE_GOVERNOR_CONFIG', 'select * from ALTER_RESOURCE_POOL', 'select * from ALTER_ROLE', 'select * from ALTER_ROUTE', 'select * from ALTER_SCHEMA', 'select * from ALTER_SEARCH_PROPERTY_LIST', 'select * from ALTER_SEQUENCE', 'select * from ALTER_SERVER_AUDIT', 'select * from ALTER_SERVER_AUDIT_SPECIFICATION', 'select * from ALTER_SERVER_CONFIGURATION', 'select * from ALTER_SERVER_ROLE', 'select * from ALTER_SERVICE', 'select * from ALTER_SERVICE_MASTER_KEY', 'select * from ALTER_SYMMETRIC_KEY', 'select * from ALTER_TABLE', 'select * from ALTER_TRIGGER', 'select * from ALTER_USER', 'select * from ALTER_VIEW', 'select * from ALTER_WORKLOAD_GROUP', 'select * from ALTER_XML_SCHEMA_COLLECTION', 'select * from ASSEMBLY_LOAD', 'select * from AUDIT_ADDLOGIN_EVENT', 'select * from AUDIT_ADD_DB_USER_EVENT', 'select * from AUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT', 'select * from AUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT', 'select * from AUDIT_ADD_ROLE_EVENT', 'select * from AUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT', 'select * from AUDIT_BACKUP_RESTORE_EVENT', 'select * from AUDIT_CHANGE_AUDIT_EVENT', 'select * from AUDIT_CHANGE_DATABASE_OWNER', 'select * from AUDIT_DATABASE_MANAGEMENT_EVENT', 'select * from AUDIT_DATABASE_OBJECT_ACCESS_EVENT', 'select * from AUDIT_DATABASE_OBJECT_GDR_EVENT', 'select * from AUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT', 'select * from AUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT', 'select * from AUDIT_DATABASE_OPERATION_EVENT', 'select * from AUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT', 'select * from AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT', 'select * from AUDIT_DATABASE_SCOPE_GDR_EVENT', 'select * from AUDIT_DBCC_EVENT', 'select * from AUDIT_FULLTEXT', 'select * from AUDIT_LOGIN', 'select * from AUDIT_LOGIN_CHANGE_PASSWORD_EVENT', 'select * from AUDIT_LOGIN_CHANGE_PROPERTY_EVENT', 'select * from AUDIT_LOGIN_FAILED', 'select * from AUDIT_LOGIN_GDR_EVENT', 'select * from AUDIT_LOGOUT', 'select * from AUDIT_SCHEMA_OBJECT_ACCESS_EVENT', 'select * from AUDIT_SCHEMA_OBJECT_GDR_EVENT', 'select * from AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT', 'select * from AUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT', 'select * from AUDIT_SERVER_ALTER_TRACE_EVENT', 'select * from AUDIT_SERVER_OBJECT_GDR_EVENT', 'select * from AUDIT_SERVER_OBJECT_MANAGEMENT_EVENT', 'select * from AUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT', 'select * from AUDIT_SERVER_OPERATION_EVENT', 'select * from AUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT', 'select * from AUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT', 'select * from AUDIT_SERVER_SCOPE_GDR_EVENT', 'select * from BIND_DEFAULT', 'select * from BIND_RULE', 'select * from BITMAP_WARNING', 'select * from BLOCKED_PROCESS_REPORT', 'select * from BROKER_QUEUE_DISABLED', 'select * from CPU_THRESHOLD_EXCEEDED', 'select * from CREATE_APPLICATION_ROLE', 'select * from CREATE_ASSEMBLY', 'select * from CREATE_ASYMMETRIC_KEY', 'select * from CREATE_AUDIT', 'select * from CREATE_AVAILABILITY_GROUP', 'select * from CREATE_BROKER_PRIORITY', 'select * from CREATE_CERTIFICATE', 'select * from CREATE_CONTRACT', 'select * from CREATE_CREDENTIAL', 'select * from CREATE_CRYPTOGRAPHIC_PROVIDER', 'select * from CREATE_DATABASE', 'select * from CREATE_DATABASE_AUDIT_SPECIFICATION', 'select * from CREATE_DATABASE_ENCRYPTION_KEY', 'select * from CREATE_DEFAULT', 'select * from CREATE_ENDPOINT', 'select * from CREATE_EVENT_NOTIFICATION', 'select * from CREATE_EVENT_SESSION', 'select * from CREATE_EXTENDED_PROCEDURE', 'select * from CREATE_EXTENDED_PROPERTY', 'select * from CREATE_FULLTEXT_CATALOG', 'select * from CREATE_FULLTEXT_INDEX', 'select * from CREATE_FULLTEXT_STOPLIST', 'select * from CREATE_FUNCTION', 'select * from CREATE_INDEX', 'select * from CREATE_LINKED_SERVER', 'select * from CREATE_LINKED_SERVER_LOGIN', 'select * from CREATE_LOGIN', 'select * from CREATE_MASTER_KEY', 'select * from CREATE_MESSAGE', 'select * from CREATE_MESSAGE_TYPE', 'select * from CREATE_PARTITION_FUNCTION', 'select * from CREATE_PARTITION_SCHEME', 'select * from CREATE_PLAN_GUIDE', 'select * from CREATE_PROCEDURE', 'select * from CREATE_QUEUE', 'select * from CREATE_REMOTE_SERVER', 'select * from CREATE_REMOTE_SERVICE_BINDING', 'select * from CREATE_RESOURCE_POOL', 'select * from CREATE_ROLE', 'select * from CREATE_ROUTE', 'select * from CREATE_RULE', 'select * from CREATE_SCHEMA', 'select * from CREATE_SEARCH_PROPERTY_LIST', 'select * from CREATE_SEQUENCE', 'select * from CREATE_SERVER_AUDIT', 'select * from CREATE_SERVER_AUDIT_SPECIFICATION', 'select * from CREATE_SERVER_ROLE', 'select * from CREATE_SERVICE', 'select * from CREATE_SPATIAL_INDEX', 'select * from CREATE_STATISTICS', 'select * from CREATE_SYMMETRIC_KEY', 'select * from CREATE_SYNONYM', 'select * from CREATE_TABLE', 'select * from CREATE_TRIGGER', 'select * from CREATE_TYPE', 'select * from CREATE_USER', 'select * from CREATE_VIEW', 'select * from CREATE_WORKLOAD_GROUP', 'select * from CREATE_XML_INDEX', 'select * from CREATE_XML_SCHEMA_COLLECTION', 'select * from DATABASE_MIRRORING_STATE_CHANGE', 'select * from DATABASE_SUSPECT_DATA_PAGE', 'select * from DATA_FILE_AUTO_GROW', 'select * from DATA_FILE_AUTO_SHRINK', 'select * from DDL_APPLICATION_ROLE_EVENTS', 'select * from DDL_ASSEMBLY_EVENTS', 'select * from DDL_ASYMMETRIC_KEY_EVENTS', 'select * from DDL_AUTHORIZATION_DATABASE_EVENTS', 'select * from DDL_AUTHORIZATION_SERVER_EVENTS', 'select * from DDL_AVAILABILITY_GROUP_EVENTS', 'select * from DDL_BROKER_PRIORITY_EVENTS', 'select * from DDL_CERTIFICATE_EVENTS', 'select * from DDL_CONTRACT_EVENTS', 'select * from DDL_CREDENTIAL_EVENTS', 'select * from DDL_CRYPTOGRAPHIC_PROVIDER_EVENTS', 'select * from DDL_CRYPTO_SIGNATURE_EVENTS', 'select * from DDL_DATABASE_AUDIT_EVENTS', 'select * from DDL_DATABASE_AUDIT_SPECIFICATION_EVENTS', 'select * from DDL_DATABASE_ENCRYPTION_KEY_EVENTS', 'select * from DDL_DATABASE_EVENTS', 'select * from DDL_DATABASE_LEVEL_EVENTS', 'select * from DDL_DATABASE_SECURITY_EVENTS', 'select * from DDL_DEFAULT_EVENTS', 'select * from DDL_ENDPOINT_EVENTS', 'select * from DDL_EVENTS', 'select * from DDL_EVENT_NOTIFICATION_EVENTS', 'select * from DDL_EVENT_SESSION_EVENTS', 'select * from DDL_EXTENDED_PROCEDURE_EVENTS', 'select * from DDL_EXTENDED_PROPERTY_EVENTS', 'select * from DDL_FULLTEXT_CATALOG_EVENTS', 'select * from DDL_FULLTEXT_STOPLIST_EVENTS', 'select * from DDL_FUNCTION_EVENTS', 'select * from DDL_GDR_DATABASE_EVENTS', 'select * from DDL_GDR_SERVER_EVENTS', 'select * from DDL_INDEX_EVENTS', 'select * from DDL_LINKED_SERVER_EVENTS', 'select * from DDL_LINKED_SERVER_LOGIN_EVENTS', 'select * from DDL_LOGIN_EVENTS', 'select * from DDL_MASTER_KEY_EVENTS', 'select * from DDL_MESSAGE_EVENTS', 'select * from DDL_MESSAGE_TYPE_EVENTS', 'select * from DDL_PARTITION_EVENTS', 'select * from DDL_PARTITION_FUNCTION_EVENTS', 'select * from DDL_PARTITION_SCHEME_EVENTS', 'select * from DDL_PLAN_GUIDE_EVENTS', 'select * from DDL_PROCEDURE_EVENTS', 'select * from DDL_QUEUE_EVENTS', 'select * from DDL_REMOTE_SERVER_EVENTS', 'select * from DDL_REMOTE_SERVICE_BINDING_EVENTS', 'select * from DDL_RESOURCE_GOVERNOR_EVENTS', 'select * from DDL_RESOURCE_POOL', 'select * from DDL_ROLE_EVENTS', 'select * from DDL_ROUTE_EVENTS', 'select * from DDL_RULE_EVENTS', 'select * from DDL_SCHEMA_EVENTS', 'select * from DDL_SEARCH_PROPERTY_LIST_EVENTS', 'select * from DDL_SEQUENCE_EVENTS', 'select * from DDL_SERVER_AUDIT_EVENTS', 'select * from DDL_SERVER_AUDIT_SPECIFICATION_EVENTS', 'select * from DDL_SERVER_LEVEL_EVENTS', 'select * from DDL_SERVER_SECURITY_EVENTS', 'select * from DDL_SERVICE_EVENTS', 'select * from DDL_SERVICE_MASTER_KEY_EVENTS', 'select * from DDL_SSB_EVENTS', 'select * from DDL_STATISTICS_EVENTS', 'select * from DDL_SYMMETRIC_KEY_EVENTS', 'select * from DDL_SYNONYM_EVENTS', 'select * from DDL_TABLE_EVENTS', 'select * from DDL_TABLE_VIEW_EVENTS', 'select * from DDL_TRIGGER_EVENTS', 'select * from DDL_TYPE_EVENTS', 'select * from DDL_USER_EVENTS', 'select * from DDL_VIEW_EVENTS', 'select * from DDL_WORKLOAD_GROUP', 'select * from DDL_XML_SCHEMA_COLLECTION_EVENTS', 'select * from DEADLOCK_GRAPH', 'select * from DENY_DATABASE', 'select * from DENY_SERVER', 'select * from DEPRECATION_ANNOUNCEMENT', 'select * from DEPRECATION_FINAL_SUPPORT', 'select * from DROP_APPLICATION_ROLE', 'select * from DROP_ASSEMBLY', 'select * from DROP_ASYMMETRIC_KEY', 'select * from DROP_AUDIT', 'select * from DROP_AVAILABILITY_GROUP', 'select * from DROP_BROKER_PRIORITY', 'select * from DROP_CERTIFICATE', 'select * from DROP_CONTRACT', 'select * from DROP_CREDENTIAL', 'select * from DROP_CRYPTOGRAPHIC_PROVIDER', 'select * from DROP_DATABASE', 'select * from DROP_DATABASE_AUDIT_SPECIFICATION', 'select * from DROP_DATABASE_ENCRYPTION_KEY', 'select * from DROP_DEFAULT', 'select * from DROP_ENDPOINT', 'select * from DROP_EVENT_NOTIFICATION', 'select * from DROP_EVENT_SESSION', 'select * from DROP_EXTENDED_PROCEDURE', 'select * from DROP_EXTENDED_PROPERTY', 'select * from DROP_FULLTEXT_CATALOG', 'select * from DROP_FULLTEXT_INDEX', 'select * from DROP_FULLTEXT_STOPLIST', 'select * from DROP_FUNCTION', 'select * from DROP_INDEX', 'select * from DROP_LINKED_SERVER', 'select * from DROP_LINKED_SERVER_LOGIN', 'select * from DROP_LOGIN', 'select * from DROP_MASTER_KEY', 'select * from DROP_MESSAGE', 'select * from DROP_MESSAGE_TYPE', 'select * from DROP_PARTITION_FUNCTION', 'select * from DROP_PARTITION_SCHEME', 'select * from DROP_PLAN_GUIDE', 'select * from DROP_PROCEDURE', 'select * from DROP_QUEUE', 'select * from DROP_REMOTE_SERVER', 'select * from DROP_REMOTE_SERVICE_BINDING', 'select * from DROP_RESOURCE_POOL', 'select * from DROP_ROLE', 'select * from DROP_ROLE_MEMBER', 'select * from DROP_ROUTE', 'select * from DROP_RULE', 'select * from DROP_SCHEMA', 'select * from DROP_SEARCH_PROPERTY_LIST', 'select * from DROP_SEQUENCE', 'select * from DROP_SERVER_AUDIT', 'select * from DROP_SERVER_AUDIT_SPECIFICATION', 'select * from DROP_SERVER_ROLE', 'select * from DROP_SERVER_ROLE_MEMBER', 'select * from DROP_SERVICE', 'select * from DROP_SIGNATURE', 'select * from DROP_SIGNATURE_SCHEMA_OBJECT', 'select * from DROP_STATISTICS', 'select * from DROP_SYMMETRIC_KEY', 'select * from DROP_SYNONYM', 'select * from DROP_TABLE', 'select * from DROP_TRIGGER', 'select * from DROP_TYPE', 'select * from DROP_USER', 'select * from DROP_VIEW', 'select * from DROP_WORKLOAD_GROUP', 'select * from DROP_XML_SCHEMA_COLLECTION', 'select * from ERRORLOG', 'select * from EVENTLOG', 'select * from EXCEPTION', 'select * from EXCHANGE_SPILL_EVENT', 'select * from EXECUTION_WARNINGS', 'select * from FT_CRAWL_ABORTED', 'select * from FT_CRAWL_STARTED', 'select * from FT_CRAWL_STOPPED', 'select * from GRANT_DATABASE', 'select * from GRANT_SERVER', 'select * from HASH_WARNING', 'select * from LOCK_DEADLOCK', 'select * from LOCK_DEADLOCK_CHAIN', 'select * from LOCK_ESCALATION', 'select * from LOG_FILE_AUTO_GROW', 'select * from LOG_FILE_AUTO_SHRINK', 'select * from MISSING_COLUMN_STATISTICS', 'select * from MISSING_JOIN_PREDICATE', 'select * from MOUNT_TAPE', 'select * from OBJECT_ALTERED', 'select * from OBJECT_CREATED', 'select * from OBJECT_DELETED', 'select * from OLEDB_CALL_EVENT', 'select * from OLEDB_DATAREAD_EVENT', 'select * from OLEDB_ERRORS', 'select * from OLEDB_PROVIDER_INFORMATION', 'select * from OLEDB_QUERYINTERFACE_EVENT', 'select * from QN__DYNAMICS', 'select * from QN__PARAMETER_TABLE', 'select * from QN__SUBSCRIPTION', 'select * from QN__TEMPLATE', 'select * from QUEUE_ACTIVATION', 'select * from RENAME', 'select * from REVOKE_DATABASE', 'select * from REVOKE_SERVER', 'select * from SERVER_MEMORY_CHANGE', 'select * from SHOWPLAN_ALL_FOR_QUERY_COMPILE', 'select * from SHOWPLAN_XML', 'select * from SHOWPLAN_XML_FOR_QUERY_COMPILE', 'select * from SHOWPLAN_XML_STATISTICS_PROFILE', 'select * from SORT_WARNINGS', 'select * from SP_CACHEINSERT', 'select * from SP_CACHEMISS', 'select * from SP_CACHEREMOVE', 'select * from SP_RECOMPILE', 'select * from SQL_STMTRECOMPILE', 'select * from TRACE_FILE_CLOSE', 'select * from TRC_ALL_EVENTS', 'select * from TRC_CLR', 'select * from TRC_DATABASE', 'select * from TRC_DEPRECATION', 'select * from TRC_ERRORS_AND_WARNINGS', 'select * from TRC_FULL_TEXT', 'select * from TRC_LOCKS', 'select * from TRC_OBJECTS', 'select * from TRC_OLEDB', 'select * from TRC_PERFORMANCE', 'select * from TRC_QUERY_NOTIFICATIONS', 'select * from TRC_SECURITY_AUDIT', 'select * from TRC_SERVER', 'select * from TRC_STORED_PROCEDURES', 'select * from TRC_TSQL', 'select * from TRC_USER_CONFIGURABLE', 'select * from UNBIND_DEFAULT', 'select * from UNBIND_RULE', 'select * from UPDATE_STATISTICS', 'select * from USERCONFIGURABLE_0', 'select * from USERCONFIGURABLE_1', 'select * from USERCONFIGURABLE_2', 'select * from USERCONFIGURABLE_3', 'select * from USERCONFIGURABLE_4', 'select * from USERCONFIGURABLE_5', 'select * from USERCONFIGURABLE_6', 'select * from USERCONFIGURABLE_7', 'select * from USERCONFIGURABLE_8', 'select * from USERCONFIGURABLE_9', 'select * from USER_ERROR_MESSAGE', 'select * from XQUERY_STATIC_TYPE'] //Variant()
   'provider' : '\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:__Win32Provider.Name="SQLServerEventProvider"' //String
}
comments powered by Disqus
WUtils.com