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 3:21 am

    #1519585

    At the subscriber, that foreign key already exists somehow so the replication can't create it. Drop or rename the one in the subscriber database.

    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