Home Forums SQL Server 2012 SQL Server 2012 - T-SQL failing on update w/ unique index error. but the index in the error is not unique RE: failing on update w/ unique index error. but the index in the error is not unique

  • July 5, 2015 at 8:55 am

    #1810325

    The index that's being complained about has as key columns (BIGINT, INT (or SMALLINT, TINYINT or BIT), DATE INT, INT). Double check the server, database, everything. It's not that uncommon for people to make that mistake. I've made it enough times.

    Don't use sysindexes and sysobjects, they were deprecated 10 years ago.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass