Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Issue with Indexed Views (NOEXPAND) in Merge Replication Expand / Collapse
Posted Monday, October 21, 2013 1:57 AM


Group: General Forum Members
Last Login: Tuesday, October 18, 2016 9:12 PM
Points: 135, Visits: 426

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
"All nations come to my light, all kings to the brightness of my rising"
Post #1506572
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse