I am configuring SQL Server Merge replication on a SQL Server 2008 R2 environment. The following errors occur during synchronisation:
The schema script '****' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
Hint 'noexpand' on object '*****' is invalid. (Source: MSSQLServer, Error number: 8171)
Get help: http://help/8171
Hint 'noexpand' on object is invalid. (Source: MSSQLServer, Error number: 8171)
I understand I can custom scripts to circumven the replication behaviour with indexed views. Any ideas on this please?
Br. Kenneth Igiri
"All nations come to my light, all kings to the brightness of my rising"