Post reply

Duplicate index name

  • September 30, 2007 at 9:42 pm

    #198529

    Hi all,

    Anyone can help me with my issue,

    I migrate my database from MS-SQL 7.0 to MS-SQL 2005,

    then for this table, every time i did an update to the data, or insert a new data, i always encounter this Duplicate index name '', when i do a lookup from my application, but if i tried to drop the table and re-create it, the error message won't appear if i do a lookup

    i've tried to drop all the index, except the primary key indexing, but i still encounter this error message,

  • October 1, 2007 at 1:40 am

    #737613

    andri (9/30/2007)

    Hi all,

    Anyone can help me with my issue,

    I migrate my database from MS-SQL 7.0 to MS-SQL 2005,

    then for this table, every time i did an update to the data, or insert a new data, i always encounter this Duplicate index name '', when i do a lookup from my application, but if i tried to drop the table and re-create it, the error message won't appear if i do a lookup

    i've tried to drop all the index, except the primary key indexing, but i still encounter this error message,

    As a first step could you run

    DBCC CHECKDB

    (http://msdn2.microsoft.com/en-us/library/ms176064.aspx)

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • October 1, 2007 at 3:54 am

    #737635

    Hi Andras,

    Thanks for the advice,

    i've already run the DBCC CHECKDB,

    and the CHECKDB found 0 allocation errors and 0 consistency errors inside the database

    Could it be because i use MS-SQL 2005,

    but i set the compatibility to MS-SQL 7.0

  • October 1, 2007 at 9:47 pm

    #737999

    It could be because of the compatibility level, but I'd think it would be a bug.

    IS there a duplicate index in sysindexes?

  • October 1, 2007 at 10:35 pm

    #738013

    Hi Steve,

    I've checked the sysindexes table, but there's no duplicate index.

    I read some article regarding update the statistic,

    could it be because of this one?

    since i migrate the database by detached it from the MS-SQL 7.0, and re-attached it to the MS-SQL2005

  • October 2, 2007 at 1:56 am

    #738036

    Hi Andri,

    have you tried updating your statistics?

    exec sp_updatestats

    (this will run UPDATE STATISTICS for all the system and user tables)

    You have rebuilt the nonclustered indexes, but just in case run DBCC DBREINDEX for the clustered primary keys you have (you mentioned that you have not modified these)

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • October 2, 2007 at 4:16 am

    #738057

    Hi Andras,

    Thanks for the advice,

    I've tried to rebuild the statistic like what you said, and also run the DBCC DBREINDEX, but it still gives me the Duplicate index name '' error

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply