Home Forums SQL Server 2008 SQL Server 2008 High Availability Error: Violation of PRIMARY KEY constraint '. Cannot insert duplicate key in object RE: Error: Violation of PRIMARY KEY constraint '. Cannot insert duplicate key in object

  • July 5, 2012 at 6:29 am

    #1509077

    change the "reference number" to auto-increment which will take care to generate the unique number everytime.

    ----------
    Ashish