Hi all, I created an alert to send an e-mail where Witness is no present on my Mirroring Configuration, but it is not firing the alert when I disconnect the Witness.
USE [msdb]
GO
/****** Object: Alert [Sin Witness] Script Date: 04/02/2008 15:15:16 ******/
EXEC msdb.dbo.sp_add_alert @name=N'Sin Witness',
@message_id=0,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@category_name=N'[Uncategorized]',
@wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER',
@wmi_query=N'SELECT * FROM DATABASE_MIRRORING_STATE_CHANGE where state=10',
@job_id=N'00000000-0000-0000-0000-000000000000'
Could someone tell me what is wrong?
Thank you