Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, October 21, 2013 1:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 17, 2014 7:45 AM
Points: 65, Visits: 269

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