SQL Server Performance

SQL Server replication Issue

Discussion in 'SQL Server 2005 Replication' started by rajesh.kolli@yahoo.com, May 22, 2009.

  1. rajesh.kolli@yahoo.com New Member

    Hi All,
    we have configured transactional replication from two different publishers to single subscriber. They are configured successfully and ran for some time. After some time one of the publication set, i mean the distributor job for one replication set is giving the below error.
    Procedure or function 'sp_MSupd_dboXXXXXXXX' expects parameter '@c1', which was not supplied. (Source: MSSQLServer, Error number: 201)
    Could not find much help on this error message.
    Anyone can help me out in finding the root cause and fix for this issue ?
    rajesh.kolli@yahoo.com, May 22, 2009
    #2

  2. satya Moderator

    Welcome to the forums.
    What is the service pack level on the involved instances on this replication?
    Is this error occurs on a specific point of time or ocassionaly?>
    satya, May 31, 2009
    #3

  3. rajesh.kolli@yahoo.com New Member

    Publisher & Distributor: Sql server 2000 SP4
    Subscriber : Sql server 2008
    issue is occuring while we are configuring another set of replication for the same subscriber database.
    rajesh.kolli@yahoo.com, Jun 3, 2009
    #4

  4. satya Moderator

    What do you mean by another set of replication to the subscriber?
    What about the service pack level on 2008 instances?
    satya, Jun 5, 2009
    #5

Share This Page