when using the RAISERROR statement you must either specify a user-defined
error message and set a system flag to record that error and you must
specify a severity level and message state when using the RAISERROR
statement.

such as RAISERROR(50010,16,1) with log 50010 is the error 16 is the error
level and 1 = the state

Hope this helps

Curt


>From: "Fang, Elaine" <Elaine.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] raiserror question
>Date: Wed, 29 Oct 2003 15:22:06 -0500
>
>Hi list,
>
>When you use raiserror, do you insert the error message to sysmessages
>table, create your own error message table, or just insert the text there
>directly?
>
>I think insert the text directly will make it harder for later
>internationalize the software. Inserting to sysmessages table seems pretty
>straight forward, but in case you need to detach/attach the app database to
>a different server, how do you export the messages adding to sysmessages
>table? Or adding our own error message table is the best way to go?
>
>Your advice is greatly appreciated!
>
>Elaine
>
>
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Get today's cartoon: http://www.LazyDBA.com
>To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] get a busy signal because you are always connected with high-speed
Internet access. Click here to comparison-shop providers.
https://broadband.msn.com

MS Sql Server LazyDBA home page