creating custom warnings?

[garwain]

I have been working with the RAISEERROR function, and it works well for critical errors that I need to have the transaction aborted and create an exception in my application, but I am having trouble with warnings. From my understanding of the helpfiles, a severity of 0-10 is a warning, and it works fine at the database level, but it won't create an exception in my software. How would I go about creating an warning message that will create an exception in a program, like the message:
"Warning: Null value is eliminated by an aggregate or other SET operation."?

 

[tlbroadbent]

I'm not clear on your question.

Do you want to create custom messages? If so, see sp_addmessage in SQL BOL.

If there is more to your question, then please explain a little more about waht you need. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.