Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 merger replication and making schema changes

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-19 : 09:33:48
Phil writes "Is there an easy way to add an index onto a column in the publisher and have it replicate down to all the subscribers using merge replication?

Thanks,
Phil"

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2002-09-19 : 13:25:48
I don't think you'll be able to add the index if the table is published for replication. If you drop the table and republish it then sure (won't work with SQL7).


===========
Paul
Go to Top of Page
   

- Advertisement -