November 17, 2003 at 9:21 am
I am trying to create an unique index on the tables with 11 fields in EM. All 11 fields need to be part of the index. I am getting this error message below:
'Create Unique Index Terminated because of a duplicate key was found for index ID 7. Most significant primary key is '000135B'.
I have wrote queries to remove all duplicates from the table. Any help with this error message would be helpful.
Patrick Quinn
TRMS Database Administrator
-------------------------
Patrick Quinn
TRMS Database Administrator
Anteon Corporation
09641-83-7722, DSN 475-7722
November 17, 2003 at 9:44 am
Hi,
from BOL :-
The maximum number of bytes in any key cannot exceed 900 in SQL Server 2000. You can define a key using variable-length columns whose maximum sizes add up to more than 900, provided no row is ever inserted with more than 900 bytes
for SQL Server 7.0 the limit is 900 total.
could this be the cause of your problem ?
Paul
November 18, 2003 at 2:24 am
I already ran a similar query and I got no results back. So, there does not appear to be any duplicates.
Patrick Quinn
TRMS Database Administrator
November 18, 2003 at 2:26 am
i was wondering whether your index wasn't considering all 11 columns (due to the 900 byte limit), and this was introducing duplicates (i.e. the first 7 columns only are being evaluated)
Paul
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply