SQL Server 2000 Analysis Services:
By TechSupport
SUPPORT PROBLEM:
Applications Supported:
COPYRIGHT NOTICE: (c) 2007 Microsoft Corporation. All rights reserved.
SUPPORT SOLUTION:
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.Note This is a “FAST PUBLISH” article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations..
For File Repair and Data Recovery, visit File Repair / Data Recovery