Sunday, February 19, 2012

Indexes

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
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)

No comments:

Post a Comment