November 7, 2008 at 5:59 pm
I am trying to replicate two indexed views. They come across to the subscriber quite nicely, but they do not have the clustered indexes attached.
I know I can have them materialize as tables on the subscriber by setting the type to "indexed view logbased", but I would prefer to keep them as views with indexes attached. Is there some way of doing this automatically?
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
November 7, 2008 at 9:53 pm
Do you have the replicate schema changes set to true? That should make sure that they stay in sync with the publisher.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 8, 2008 at 12:52 am
Yes, and changes to the view definition do get propogated, but the indexes (even the clustered index) does not.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply