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 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.
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 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.
|||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.

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.

Enterprise Manager Closing with Access Violation

Hi, can anybody help me
I am using SQL Server 2000 Developer Edition
I am getting the following error
Unhandled exception at 0x0100bb5b in mmc.exe: 0xC0000005: Access violation reading location 0x00000064.
I'm sure its because of the following:
Access Violation Error Message in Mmc.exe After You Apply Internet Explorer Privacy Update from Q316116 or After You Apply Internet Explorer 6 SP1
How do I fix it?
Is there a patch/fix available
Did you try re-installing the client tools and/or reinstalling SP3a?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Noel" <anonymous@.discussions.microsoft.com> wrote in message
news:AA995939-AD26-485B-ABE4-AE59C838C1CE@.microsoft.com...
> Hi, can anybody help me
> I am using SQL Server 2000 Developer Edition
> I am getting the following error
> Unhandled exception at 0x0100bb5b in mmc.exe: 0xC0000005: Access violation
reading location 0x00000064.
> I'm sure its because of the following:
> Access Violation Error Message in Mmc.exe After You Apply Internet
Explorer Privacy Update from Q316116 or After You Apply Internet Explorer 6
SP1
> How do I fix it?
> Is there a patch/fix available
>
>
|||Yes, error still persists

Enterprise Manager Closing with Access Violation

Hi, can anybody help me
I am using SQL Server 2000 Developer Edition
I am getting the following error
Unhandled exception at 0x0100bb5b in mmc.exe: 0xC0000005: Access violation r
eading location 0x00000064.
I'm sure its because of the following:
Access Violation Error Message in Mmc.exe After You Apply Internet Explorer
Privacy Update from Q316116 or After You Apply Internet Explorer 6 SP1
How do I fix it?
Is there a patch/fix availableDid you try re-installing the client tools and/or reinstalling SP3a?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Noel" <anonymous@.discussions.microsoft.com> wrote in message
news:AA995939-AD26-485B-ABE4-AE59C838C1CE@.microsoft.com...
> Hi, can anybody help me
> I am using SQL Server 2000 Developer Edition
> I am getting the following error
> Unhandled exception at 0x0100bb5b in mmc.exe: 0xC0000005: Access violation
reading location 0x00000064.
> I'm sure its because of the following:
> Access Violation Error Message in Mmc.exe After You Apply Internet
Explorer Privacy Update from Q316116 or After You Apply Internet Explorer 6
SP1
> How do I fix it?
> Is there a patch/fix available
>
>|||Yes, error still persists