Dropping a User-Defined Error Message : sp_dropmessage « System « SQL Server / T-SQL

1. SQL Server / T-SQL
2. System
3. 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

 

Related examples in the same category