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: 2 days ago @ 4:35 AM
Points: 117, Visits: 390

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?
Post #1506572
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse