SQL Server sys.messages -

i have database on 1 server added custom error messages sys.messages view using sp_addmessage stored procedure.

i find when restore database onto server sys.messages not copied. first time using custom messages in sys.messages view.

where might going wrong?

am supposed copy custom error messages each time restore db?

or supposed add error messages in master db?

i doing own research wondering if point me in right direction

thanks nomad

you have set custom error messages again either manually or original script

you can script them out of course

select    'exec sp_addmesssage ' + ...    sys.messages    ... 

personally, why don't use them: become maintenance overhead if have different entries different databases on same server. i've had 3rd party app use them , cause conflicts another... ggrrrrr