Hi, the situation is, when i try to insert duplicate records into a table, the error message given by sql server is w.r.t error number 2627.

I entered a user defined error message using sp_addmessage 50001, 14, 'No duplicate entries' into the sysmessages table.

but when i trap for @@error <> 0 like

insert into <table> (<column>) values (<value>)
if @@error <> 0
    RAISERROR(50001,14,1)

I see the output like:
<System error message>
<My error message>

Here the user defined error message is appended.

The question is, instead of getting the system defined error message, can only my error message be displayed. Can i program in such a way in order to shunt the system error messages for error numbers like 2627.

TIA
Praveen