Solved

Getting Error “The schema script ‘’ could not be propagated to the subscriber” when setting up merge replication

Posted on 2010-11-19
1
2,190 Views
Last Modified: 2012-05-10
I am trying to remote subscription on SQL Server 2005 to a SQL Server 2008 publisher using a SQL Server 2008 distributor. Both the publisher and distributor are on a different domain but are connected through a VPN.

The subscription is never getting initialized as a result. The full 2 errors are: The schema script '' could not be propagated to the
subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
and
Incorrect syntax near the keyword 'drop'. (Source: MSSQLServer, Error number: 156)
0
Comment
Question by:jhakie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 total points
ID: 34191153
Well if you use features only availiable in sql2008 on the database. This doesn't work. You need the same version for subscriber.

Lookat: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_25192581.html
And the comment I refer to begins with: "quote: 'ALTER TABLE SET LOCK ESCALATION should not be used if schema change replication ..."

//Marten
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question