Drops user-defined messages from sysusermessages.
sp_dropmessage message_num [, language]
is the message number of the message to be dropped. Message numbers must have a value of 20000 or higher.
is the language of the message to be dropped.
Removes the French version of the message with the number 20002 from sysusermessages:
sp_dropmessage 20002, french
The language parameter is optional. If included, only the message with the indicated message_num in the indicated language is dropped. If you do not specify a language, all messages with the indicated message_num are dropped.
Only the Database Owner, a System Administrator, or the user who created the message being dropped can execute sp_dropmessage.
System procedures sp_addmessage, sp_getmessage
