Indexed Views - Clustered Index is NOT replicated (not scripted by

Indexed Views - Clustered Index is NOT replicated (not scripted by

Post by ams » Wed, 03 Mar 2010 06:06:03


Using SQL 2005 SP2.
I have a publication that contains indexed views, and some other objects
that query the indexed view using WITH (NOEXPAND). Currently replication
fails because the CLUSTERED INDEX on the view is NOT replicated. I've
experimented with various schema options but nothing changes. The view is
replicated but not the clustered index on that view.

I've seen some discussion on replicating indexed views to a table, but I
would like to replicate indexed view schema fully. (Including the clustered
index on that view).
Is there a way to make this work?

Thanks.
 
 
 

Indexed Views - Clustered Index is NOT replicated (not scripted by

Post by Ben Thu » Wed, 03 Mar 2010 06:56:34

Can you post the sp_addarticle invocation that you used? I'm
specifically interested in what you used for the @type and
@schema_option parameters. Thanks!
Ben