WMI Provider for Server Events

发布时间：2020-12-12 14:42:27 所属栏目：MsSql教程来源：网络整理

导读：You can use WMI to monitor server events.This provider manages a WMI namespace for each instance of SQL Server 2008. The name of the namespace is in the format rootMicrosoftSqlServerServerEventsinstance name.To monitor a default instan

You can use WMI to monitor server events.This provider manages a WMI namespace for each instance of SQL Server 2008. The name of the namespace is in the format
rootMicrosoftSqlServerServerEventsinstance name.To monitor a default instance on a remote computer — for example,DEMOPC — you can use a named
space,DEMOPCrootMicrosoftSqlServerServerEventsMSSQLSERVER.

To check whether the Service Brokers are enabled on a SQL Server instance,and to get the Service Broker instance GUID in each database:

SELECT name,is_broker_enabled,service_broker_guid FROM sys.databases

To enable Service Broker for a database — for example,the msdb database — use the ALTER DATABASE statement:

ALTER DATABASE msdb SET ENABLE_BROKER

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!