Getting Error “The schema script ‘’ could not be propagated to the subscriber” when setting up merge replication
Posted on 2010-11-19
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)
Incorrect syntax near the keyword 'drop'. (Source: MSSQLServer, Error number: 156)