Post reply

Violation of identity column

  • August 6, 2003 at 2:53 pm

    #80780

    Hi all

    i have identity column (bigint type) on my table defined as primary key. Inserting data by insert into ... select command with 700 000 rows (aprox). Command failed with error:

    Server: Msg 2627, Level 14, State 1, Line 1

    Violation of PRIMARY KEY constraint 'PK_App_DuplicityExpressions'. Cannot insert duplicate key in object 'App_DuplicityExpressions'.

    PK_App_DuplicityExpressions is defined as clustered index on indentity column only.

    Any ideas how to solve this problem?

    P.S: Configuration: MSSQL Server Enterprise SP3, 2GB RAM, 2x2GHz CPU, 4x80GB HDD.


    ****************************************
    1: The question is ... "What is a MahnaMahna"?
    2: The question is ... "Who cares?"
    ****************************************

  • August 6, 2003 at 3:39 pm

    #468898

    heh ... i found this know-how ... Q290915 (MS Knowledge base) ... http://support.microsoft.com/default.aspx?scid=kb;en-us;290915

    But i don't understand the Status paragraph:

    This problem was first corrected in SQL Server 2000 Service Pack 1.

    I have SP3 🙁

    Solution: use DBCC CHECKIDENT


    ****************************************
    1: The question is ... "What is a MahnaMahna"?
    2: The question is ... "Who cares?"
    ****************************************

Viewing 2 posts - 1 through 1 (of 1 total)

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