Indexed Views - Clustered Index is NOT replicated (not scripted by
in [Replication]
|
Prev: Replication agents are idles
Next: Perform only schema change replication and avoid data replication.
From: jk on 1 Mar 2010 16:06 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.
From: Ben Thul on 1 Mar 2010 16:56
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 On Mar 1, 3:06 pm, jk <j...(a)discussions.microsoft.com> wrote: > 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. |