Post reply

Error in replication

  • February 22, 2005 at 9:41 am

    #163776

     I have replication set up between 2 servers to copy all databases from one to the other. All databases work fine except for one. The distribution agent shows up last command as:

    exec dbo.sp_MSinit_subscription_agent @publisher = N'XXX',@publisher_db = N'YYY', @publication = ZZZ', @subscription_type = 0

     and error as:

    Invalid object name 'MSsubscription_agents'.

    Is there an easy way to trace and find out  what/where the error is?

    Any help will be greatly appreciated.

    TIA

  • February 22, 2005 at 2:14 pm

    #543561

    Look for the table MSsubscription_agents on your target (subscription) database. make sure that the user you are using for replication has the access on this table.

     

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply