Unbinds a user-defined message from a constraint.
sp_unbindmsg constrname
is the name of the constraint from which a message is to be unbound.
Unbinds a user-defined message from the constraint positive_balance:
sp_unbindmsg positive_balance
You can bind only one message to a constraint. To change the message bound to a constraint, use sp_bindmsg; the new message number replaces any existing bound message. It is not necessary to use sp_unbindmsg first.
To retrieve message text from the sysusermessages table, execute sp_getmessage.
Only the object owner can execute sp_unbindmsg.
System procedures sp_addmessage, sp_bindmsg, sp_getmessage
