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





MS Sql Server LazyDBA home page