Equivalant Exception for DUP_VAL_ON_INDEX for SQL Server

Hello,
We are in the process of migrating the Oracle database to SQL Server. We nee
d 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.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.shirodkar@.lycos.com> wrote:

>Hello,
>We are in the process of migrating the Oracle database to SQL Server. We ne
ed the help on the Exception Handling in SQL Server.
>The existing Oracle stored procedure is using the Exception DUP_VAL_ON_INDE
X, which raises when the duplicate values gets inserted in the Indexed colum
n. (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.|||Hello Sue,
Good Morning. Thank you very much for the very useful help. Yesterday late e
vening i tried the same and was at the conclusion of the error no. 2601 as t
he equivalant in SQL.
Your ans. supports that and i an confirmed now.
Thank you once again.