Home Forums SQL Server 2005 SS2K5 Replication There is already an object named 'FK_OSS_KBN_PC' in the database.(Error: 14151, Severity: 18, State: 1) RE: There is already an object named 'FK_OSS_KBN_PC' in the database.(Error: 14151, Severity: 18, State: 1)

  • July 31, 2012 at 4:26 am

    #1519601

    It's not a duplicate key. It's a foreign key with the same name.

    Check the subscriber database for objects with that name. If you find one, either drop it (if it's the same foreign key that the replication is trying to create) or rename it.

    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