How to receive mails, when a record is entered into my error log table?

I'm using SQL Server 2000.

I want to receive a mail for every new entry, into my error log table. I want to receive the inserted value in the form of subject of the mail and some other text column's value as the body of the mail.

Plz. guide me.

Best Regards

Trinadh P.

SQLNS can certainly do this, but depending on your circumstances another technology - including Database Mail or an external SMTP XP - may be better suited for the task.

If you opt for the SQLNS route, take at look at one of the samples provided with the install and mimic one that uses the SQL Server Event Provider.

HTH....

Joe