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 10:16 pm

    #1520068

    Hi,

    We didn't create that Key.And today we are getting again the below error.

    Error:

    The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. (Source: MSSQLServer, Error number: 21074)

    Note:We have kept subscription never expires.Still why we are getting this error.

    I am not getting clear idea about rename and dropping key.Is it ok to rename or drop the foreign key with same name from subscriber??