Replicate a view

[Afaq]

Hi,

I have some indexed views as part of my article. From my application i alter
the view as i can add columns dynamically in the underlying tables. The
replciation of the columns is not a issue but i cannot replicate the altered
view. I am using merge replciation between SQL Servers and MSDE's

Thanks in advance

Afaq

[Jayanthi Sampathkumar [MSFT]]

In SQL server 2000 we do not replicate alter table statements. So it is
expected that when you alter the view definition on the publisher the
subscriber does not get the altered columns. In SQL server 2005 we do
replicate the alter view statement and the subscribers will get the new
columns.

Could you also elaborate on what you mean by "I cannot replicate teh altered
view"?

Thanks,
Jayanthi

"Afaq" <Af...@discussions.microsoft.com> wrote in message
news:6BCAACFE-8030-46B3...@microsoft.com...