May 20, 2005 at 3:37 am
I have a newly installed version on SQL Server 2000 (SP3) on a new server which no matter what I seem to do, refuses to fire Alerts.
The startup account is the same for the MS SQL Server and the SQLServerAgent services and is also the same account used by other SQL Servers running without this problem. The mail profile created on the server is the same as the startup account and all the email "Tests" within SQL Server Agent work without a problem.
If I create a new Alert to fire when a specific error occurs, then use raiserror to initialise the error, the alert does not fire, but the error is getting logged in the SQL Server logs.
I have tried all the items raise on http://www.databasejournal.com/features/mssql/article.php/3081171 and none of them fix my problems.
Can anyone suggest a solution?
May 20, 2005 at 10:20 am
Does the error appear in the windows event log under applications?
When running RAISERROR, are you including the "with log" option?
SQL = Scarcely Qualifies as a Language
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply