Hi All
I am trying to setup alerts on SQL Server 2005 and new install of SQL Server 2008. When trying to create the alert I am getting: -
Msg 22022, Level 16, State 1, Line 0
SQLServerAgent Error: WMI error: 0x8004100e.
Msg 14511, Level 16, State 1, Procedure sp_verify_alert, Line 300
The @wmi_query could not be executed in the @wmi_namespace provided. Verify that an event class selected in the query exists in the namespace and that the query has the correct syntax.
Any assistance would be much appreciated, I have seen the microsoft post about the server name length and all mine are under 10 characters long.
Thanks
Mike