raiserror on errors #5XXXX

[alan]

I've defined an error message 50002, severity level 16 that is logged.
I've defined and alert on error number 50002 to catch it.

I can raise the error using raiserror and it looks like this -
Raiserror ( 50002,16, 1, @tname)
The error is raised and the text is printed, but the alert is never generated.
Am I missing something?
Thanks in advance.

[Ray Miao]

On 11/12/98 4:04:57 PM, alan wrote:
> I've defined an error message 50002, severity level 16 that is
> logged.
I've defined and alert on error number 50002 to catch it.

I
> can raise the error using raiserror and it looks like this -

> Raiserror ( 50002,16, 1, @tname)
The error is raised and the text is
> printed, but the alert is never generated.
Am I missing something?
Thanks
> in advance.

Depends on the event you monitored, you can use performance monitor's alert or scheduled task to generate alert. System will write error message to SQL errorlog & NT eventlog. If you want system inform you every time the error occurs, you can create a task to send win message to your desktop, then configure SQL Alert to execute this task when the alert generated.