1

Recently I've replaced a sql server (2008R2). I've reinstalled hosted apps and restored backups of databases. All seems to work as expected except that these events are shown in the eventlog :

id 18054 in MSSQLSERVER Error 150010, severity 16, state 96 was raised,
but no message with that error number was found in sys.messages.
If error is larger than 50000, make sure the user-defined message 
is added using sp_addmessage

I can get the message from the old server using select * from sys.messages where message_id='150010'

Now I'd like to know how to copy all the msg with id > 50000 on the new server? Do I have to restore a backup of the master db ?

1

Since you can still access the old server run something like this, save the output to a file and run that into the new server. You may have to adjust the varchar lenghts or the quotes for your messages but it's what I used for a recent migration.

select 'exec sp_addmessage ' + convert(varchar(6), message_id) + ', ' + convert(varchar(6), severity) + ', ''' + text + '''' 
from sys.messages where message_id > 50000 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.