sp_dropmessage System Stored Procedure

Drops a specified error message from the sysmessages system table.

Syntax

sp_dropmessage [msg_id [, language | 'all']]

where

msg_id

Specifies the message to drop. This parameter must be a user-defined message with a msg_id greater than or equal to 50000.

language

Specifies the language of the message to drop.

'all'

Drops all language versions of msg_id.

Remarks

If no parameters are supplied, a syntax diagram will be displayed.

Example

This example drops the message (number 50001) from sysmessages.

sp_dropmessage 50001
go
    Message dropped.

Permission

Execute permission defaults to the system administrator, who can transfer it to other users.

Table Used

sysmessages

See Also