Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to pass Alert information to a stored procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-10-13 : 08:00:34
Michael writes "When you define an Alert which is set to fire for, say error 18456 Login failed..., and if a stored procedure is associated with this alert, then there appears to be no way to pass information from the alert to the store procedure. The obvious reason is to log this. And the alternative of going via the Windows event log is really a bit of a hassle.
SQL Server 2000 SP3a"
   

- Advertisement -