on a sql server 2008 r2 server i am seeing following error in sql agent log
'unable to register the alert xxx with wmi porivder. The alert is ignored. WMI error 0x8004100e.
I am running query 'select * from DATABASE_MIRRORING_STATE_CHANGE' . Also the sql agent account is part of sysadmin. I have setup this alert to monitor mirroring state change alerts.
any help will really appriciate.
it works if you specify the database in the query-
SELECT * FROM DATABASE_MIRRORING_STATE_CHANGE WHERE Database = 'MyDatabase'
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?