Hi,

I have trouble getting the alerts to work on SQL 2005.

Below I define a custom message and a custom alert.
When I raise the error though the alert never fires.

Any ideas why that would be?

Thanks,
Patrick

-------------------------------------------------------
USE master
GO
EXEC sp_addmessage 50001, 16, N'The version of SQL Server has been
requested.'
GO

------------------------------------------------------
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'TEST Alert',
@message_id=50001,
@severity=0,
@enabled=1,
@delay_between_responses=5,
@include_event_description_in=5,
@notification_message=N'TEST',
@category_name=N'[Uncategorized]',
@job_id=N'00000000-0000-0000-0000-000000000000'

------------------------------------------------------
RAISERROR (50001, 16, 1)
------------------------------------------------------