FTP Replication

  • I get the following message when I execute my pull sucbscription which is set up to replicate using FTP replication: Category:COMMAND

    Source: Failed Command

    Number: 0

    Message: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}

    Category:SQLSERVER

    Source: Main Server(vs remote)

    Number: 2812

    Message: Could not find stored procedure ''.

    Category:NULL

    Source: Merge Replication Provider

    Number: -2147200999

    Message: The process was successfully stopped.

    In the same order, does this point to anything you know of?

  • It should be a proc in your master db - perhaps deleted somehow?

    Andy

  • I was finnaly able to successfully replicate via FTP from our external WAN to a SQL Server on the LAN! The problem I was experiencing was solved when I included the ftp folder as part of the home directory on the FTP host computer where the remote SQL Server database is located. What I thought was weird was that a sub directory was created in the ftp home directory that was also called ftp by the Snapshot agent. Thanks for your assistance and I look forward to future correspondence.

    I get the following message when I execute my pull sucbscription which is set up to replicate using FTP replication: Category:COMMAND

    Source: Failed Command

    Number: 0

    Message: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}

    Category:SQLSERVER

    Source: Main Server(vs remote)

    Number: 2812

    Message: Could not find stored procedure ''.

    Category:NULL

    Source: Merge Replication Provider

    Number: -2147200999

    Message: The process was successfully stopped.

    In the same order, does this point to anything you know of?

    [/quote]

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

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