I have nested stored procedures and I have created system defined error numbers and would like to raise an error in the nested stored procedure. However when I run this the error number raised in the parent stored procedure is 50000 and not the defined error number. Has anyone come across this and know how to handle it? Many thanks
Are you specifying an error message in the parent proc? If so then that gets an error number of 50000 From BOL: > When msg_str is specified, RAISERROR raises an error message with an error number of 50000.