Advertisement

03.09.2008 at 09:48AM PDT, ID: 23226729
[x]
Attachment Details

Can't create UNIQUE INDEX becuase of null

Asked by ateam in MS SQL Server, Databases Miscellaneous

Tags: Microsoft, SQL Server, 2000, ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 28. Most significant primary key is ''.

I try to create UNIQUE INDEX on sql server table but I get an error massge becuase of the null in my key.

I have 3000 records in my table and I want to add this Unique index to the row and ignore the the null.

here is my error massge:
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 28. Most significant primary key is '<NULL>'.Start Free Trial
[+][-]03.09.2008 at 09:56AM PDT, ID: 21081822

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]03.09.2008 at 10:00AM PDT, ID: 21081830

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]03.09.2008 at 11:33AM PDT, ID: 21082188

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, Databases Miscellaneous
Tags: Microsoft, SQL Server, 2000, ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 28. Most significant primary key is '<NULL>'.
Sign Up Now!
Solution Provided By: dportas
Participating Experts: 3
Solution Grade: B
 
 
[+][-]03.09.2008 at 11:46AM PDT, ID: 21082219

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628