Agent message code 2812. Could not find stored procedure ‘sp_MSget_min_seqno’.

Article ID: 2400023 - View products that this article applies to.
Expand all | Collapse all

Symptoms

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'.

Cause

The behavior is by design. SQL Server 2008 Peer Pull Distribution Agent cannot be used in a mixed version Replication topology.

Resolution

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.

 

More Information

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 for other considerations.

Properties

Article ID: 2400023 - Last Review: September 15, 2010 - Revision: 2.0
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
Keywords: 
KB2400023

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com