Results 1 to 3 of 3

Thread: Can not insert duplicate key with indix '#...

  1. #1
    Join Date
    Aug 2004
    Posts
    188

    Can not insert duplicate key with indix '#...

    Hi guys, I get this error. How do I find the index or table that is causing the issues.

    Thanks!

    The database reported the following error:
    Source: Microsoft OLE DB Provider for SQL Server
    Error code: 0x80040e2f
    SQL error code: 2601
    Description: Cannot insert duplicate key row in object '#d_______________________________________________ __________________________________________________ _________________0000000001B6' with unique index '#dvidx'.
    Command 1 was:

  2. #2
    Join Date
    Aug 2004
    Posts
    188
    I have been looking at indexes and tables and cant seem to find anything with that id or name.

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    It's temp table in tempdb.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •