Chapter 1: System Procedures

sp_dropmessage

Drops user-defined messages from sysusermessages.

sp_dropmessage message_num [, language]

message_num: is the message number of the message to be dropped. Message numbers must have a value of 20000 or higher.

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.

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
32	drop	sp_dropmessage	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – Message number Proxy information – Original login name, if set proxy in effect
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect