ERROR HANDLING IN SQL SERVER

[sandy3110]

Hi,

I want to trap sql server error in store procedure.
With using Raiserror keyword...I can give user defined
errors but i dont want sql server error.
So it still displaying my error message and sql server(sysmessage).
What do I do for that?Any soLn.
Please reply me at sandy_3110@rediffmail.com ASAP.

Thanks & Regards,
Sandy

 

[tlbroadbent]

Can you give an example to clarify your meaning? Please post your SQL statement and the messages that result.

Thanks, Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.