Error message in Stored procedure

[IamAmit]

Hello friends, I want to display error message if any error occurs while executing my stored procedure(for debugging purposes). How to display an error message in stored procedure (I am using sql server 2005) Thanks

[leoinfo]

For debuging purposes, you can add after each (SELECT, INSERT, UPDATE, DELETE, EXECUTE ...) command something like this:

IF @@ERROR <> 0
PRINT 'Insert into MyTable failed'

[TheFM234]

Raiserror('Message', 16, 1)

The above message will show up like an error thrown by the server. It'll get caught by try/catch blocks.