Suppress error messages from being displayed

[vaidyanathanpc]

Hi,
I have written a procedure to send mail.

CREATE procedure PCWishes
as
declare @rc int
Begin
exec @rc = master.dbo.xp_sendmail @recipients='Murali_K', @Subject='Service Anniversary!!',@Message='Hello'
if @rc = 1
begin
print 'Error'
end
End


The mail id given in the recepients list is an invalid mail id. When I execute this procedure from the query analyzer, I get the the following error message.

Server: Msg 17921, Level 18, State 1, Line 0
A recipient was specified ambiguously.

Error

In the above error message, I want to suppress the SQL Server error message and display only the error message ("Error&quot given in the print statement in my stored procedure. How do I do this?

Thanks in advance
P.C. Vaidyanathan

 

[tlbroadbent]

Yo cannot suppress the SQL Error messages. Terry L. Broadbent - DBA
Computing Links:

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

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