Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

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

↑ Back to the top

Cause

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

↑ Back to the top

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.

 

↑ Back to the top

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

↑ Back to the top

Keywords: vkball, kb

↑ Back to the top

Article Info
Article ID : 2400023
Revision : 1
Created on : 1/8/2017
Published on : 9/15/2010
Exists online : False
Views : 228