Equivalant Exception for DUP_VAL_ON_INDEX for SQL Server

[Sue Hoegemeier]

Duplicates for a unique index insert return the error number
is 2601. The error message depends on the object name but
it's:
Cannot insert duplicate key row in object '%.*ls' with
unique index '%.*ls'.

-Sue

On Wed, 31 Mar 2004 03:21:06 -0800, Aparna
<aparna.s...@lycos.com> wrote:

>Hello,
>
>We are in the process of migrating the Oracle database to SQL Server. We need the help on the Exception Handling in SQL Server.
>
>The existing Oracle stored procedure is using the Exception DUP_VAL_ON_INDEX, which raises when the duplicate values gets inserted in the Indexed column. (typcially used with INSERT statement)
>
>We need the equivalant statement for the exception mentioned above.
>
>I request you to elp us out in this case.
>
>Thanking in advance.

[Aparna]

Hello Sue,

Good Morning. Thank you very much for the very useful help. Yesterday late evening i tried the same and was at the conclusion of the error no. 2601 as the equivalant in SQL.
Your ans. supports that and i an confirmed now.

Thank you once again.