Home Forums SQL Server 2012 SQL 2012 - General Identity key (unique column) not behaving properly RE: Identity key (unique column) not behaving properly

  • September 23, 2014 at 10:39 am

    #1747577

    adrian.buzila (9/23/2014)

    I have the same problem with SQL2012 (11.0.5058.0) on many tables.

    I checked for reseed and set identity_insert. It's not the case.

    If there is a unique constraint insert fails. It not sql server inserts duplicates.

    @SQL-Lover Thanks for posting.

    No problem.

    It may help others if you mark my last post (the trace flag) as solution.

    Thanks.