Article ID: 2400023 - View products that this article applies to.
After configuring a SQL 2008 PULL subscription to a SQL Server 2005 Peer-2-Peer Replication topology, the Pull Distribution Agent fails with the following error message.
Agent message code 2812. Could not find stored procedure 'sp_MSget_min_seqno'.
The behavior is by design. SQL Server 2008 Peer Pull Distribution Agent cannot be used in a mixed version Replication topology.
SQL Server 2008 Peer subscriber is unable to PULL from a SQL Server 2005 Publisher/Distributor. When configuring Peer to Peer replication in environments that includes a mix of both SQL Server 2005 and SQL Server 2008 servers ensure that the subscriptions to SQL Server 2008 servers are configured as push subscriptions instead of pull subscriptions.
New code was added to the SQL Server Distribution (Distrib.exe) that calls stored procedures found only in the SQL Server 2008 Distribution database. In a mixed topology, the SQL Server 2008 Pull Distribution Agent is connected to a SQL Server 2005 Distribution database which does not contain the required stored procedures
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2400023 - Last Review: September 15, 2010 - Revision: 2.0
Contact us for more help