How to send an error message from a Stored Proc?

[Sheila]

Inside my stored procedure I want to first check if referential integrity is being violated. If so, I want to return an error message. How can I do this?

Please help.

Thanks in advance.
Sheila

[Chris]

4 different ways:

1. RAISERROR
2. Send a mail message - XP_Sendmail
3. Log the even to the event log - XP_LogEvent
4. Return a user defined code as output back to the application and have that
enum value contained in a com object that will render the error.

There are others of course, but these are the most widely used. It really depends upon you business need.

------------
Sheila at 8/29/00 5:04:25 PM


Inside my stored procedure I want to first check if referential integrity is being violated. If so, I want to return an error message. How can I do this?

Please help.

Thanks in advance.
Sheila