Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesI have started using WMI Event Alerts on SQL Server. A simple example being : Namespace : \\.\root\cimv2 Query: SELECT * from __InstanceModificati onEvent WITHIN 30 WHERE TargetInstance ISA 'Win32_Processor' AND TargetInstance.LoadPercentage > 80 My Question : What is SQL server looking for from the query to determine if an alert needs to be triggered. My interpretation from this simple script is : If any row count is returned (ie SELECT * from ..) then the alert will be fired. Is this correct for all WMI Event Alerts ? Is that all it is ? ie Rowcount returned > 0 ? Thanks s
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread