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,141 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
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

860 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