all groups > sql server replication > september 2005 >
You're in the

sql server replication

group:

Indexes


Indexes andrew bourne
9/28/2005 4:13:45 PM
sql server replication: Hi all, got a feeling its not possible because ive looked for sp's, and
there dont seem to be any, is it possible to add indexes with merge
replication in place?

Thanks Andrew

Re: Indexes Paul Ibison
9/29/2005 9:03:44 AM
Andrew,
this is no problem. Just go ahead and add them. They won't replicate to the
subscribers (even in SQL Server 2005) but you can use sp_addscriptexec to
ensure this takes place.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button