I am configuring SQL Server Merge replication on a SQL Server 2008 R2 environment. The following errors occur during synchronisation:
Error 2
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
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising