sp_dropmessage

Syntax

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.
language – is the language of the message to be dropped.
When you include the optional language parameter, 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.

Example 1 – Removes the French version of the message with the number 20002 from sysusermessages:
```
sp_dropmessage 20002, french
```

The permission checks for sp_dropmessage differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the user who created the message or the database owner, or a user with `own database` privilege on the current database.
Disabled	With granular permissions disabled, you must be the user who created the message, the database owner, or a user with sa_role.

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

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	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