SQL Server/T-SQL/System/sp dropmessage

Dropping a User-Defined Error Message

 
3>
4> -- Creating the new message
5> EXEC sp_addmessage
6> 100001,
7> 14,
8> N"The current table %s is not updateable by your group!"
9> GO
Msg 15043, Level 16, State 1, Server BCE67B1242DE45A\SQLEXPRESS, Procedure sp_addmessage, Line 137
You must specify "REPLACE" to overwrite an existing message.
1>
2>
3> EXEC sp_dropmessage 100001
4> GO