Home Forums SQL Server 2008 SQL Server 2008 Administration Replication job error once server rebootes RE: Replication job error once server rebootes

  • September 25, 2017 at 5:26 am

    #1960697

    aminbangash110 - Monday, September 25, 2017 5:21 AM

    I can't find the above stored procedure you mentioned and ms sql server 2008 R2 i'm using, where to find the replication monitory. Can you tell me exactly about it please.

    Are you actually using replication or are you using SSIS?

    Re-reading the full original post looks to me like its a SSIS package not replication.

    The error you have is your trying to violate the PRIMARY KEY, you cannot do this, look though the job, debug it and find the task causing the error.  The problem for example is because your trying to insert the ID 100 into cdr_main when ID 100 already exists in cdr_main

    sp_browserplcmds, is in the distributor database, replication monitor, can be opened by right clicking the replication folder in SSMS.