create unique index error message

  • 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

  • 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

  • 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

  • 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