Problem with RAISERROR

[omauri]

Hi. How can I make a personal error message with T-SQL code??? Besides, How Can I insert variable data in a personal error message? Thanks...

 

[tlbroadbent]

Use sp_addmessage system stored procedure. It is well documented in the T-SQL reference of SQL BOL. I also recommend reading the information in SLQ BOL about RAISERROR.

See the following WEB links.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_adda_8zdx.asp

http://msdn.microsoft.com/library/en-us/trblsql/tr_err_odbc_7m0j.asp

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ra-rz_5ooi.asp

Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com