Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 2400023 - Last Review: September 15, 2010 - Revision: 2.0
Agent message code 2812. Could not find stored procedure ‘sp_MSget_min_seqno’.
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.
APPLIES TO
- Microsoft SQL Server 4.21a Standard Edition
- Microsoft SQL Server 6.0 Standard Edition
- Microsoft SQL Server 6.5 Standard Edition
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft SQL Server 2000 Service Pack 3
- Microsoft SQL Server 2000 64-bit Edition
- Microsoft SQL Server 2000 Analysis Services
- Microsoft SQL Server 2000 Analysis Services Service Pack 4
- Microsoft SQL Server 2000 Developer Edition
- Microsoft SQL Server 2000 Enterprise Edition
- Microsoft SQL Server 2000 Enterprise Evaluation Edition
- Microsoft SQL Server 2000 Personal Edition
- Microsoft SQL Server 2000 Personal Edition Service Pack 3
- Microsoft SQL Server 2000 Reporting Services
- Microsoft SQL Server 2000 Reporting Services Service Pack 1
- Microsoft SQL Server 2000 Standard Edition
- Microsoft SQL Server 2000 Windows CE Edition 2.0
- Microsoft SQL Server 2000 Windows CE Edition
- Microsoft SQL Server 2000 Workgroup Edition
- Microsoft SQL Server 2005 Analysis Services
- Microsoft SQL Server 2005 Beta 2
- Microsoft SQL Server 2005 Compact Edition
- Microsoft SQL Server 2005 Compact Edition Service Pack 1
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
- Microsoft SQL Server 2005 Enterprise X64 Edition
- Microsoft SQL Server 2005 Evaluation Edition
- Microsoft SQL Server 2005 Everywhere Edition Community Technology Preview
- Microsoft SQL Server 2005 Express Edition
- Microsoft SQL Server 2005 Express Edition Toolkit
- Microsoft SQL Server 2005 Express Edition with Advanced Services
- Microsoft SQL Server 2005 Notification Services
- Microsoft SQL Server 2005 Reporting Services
- Microsoft SQL Server 2005 Service Pack 2
- Microsoft SQL Server 2005 Service Pack 3
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Standard X64 Edition
- Microsoft SQL Server 2005 Workgroup Edition
- Microsoft SQL Server 2008 Analysis Services
- Microsoft SQL Server 2008 Community Technology Preview
- Microsoft SQL Server 2008 Developer
- Microsoft SQL Server 2008 Enterprise
- Microsoft SQL Server 2008 Enterprise Evaluation
- Microsoft SQL Server 2008 Express
- Microsoft SQL Server 2008 Express with Advanced Services
- Microsoft SQL Server 2008 R2 Analysis Services
- Microsoft SQL Server 2008 R2 Datacenter
- Microsoft SQL Server 2008 R2 Developer
- Microsoft SQL Server 2008 R2 Enterprise
- Microsoft SQL Server 2008 R2 Express
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate