sql server replication: Does replication copy indexes or only raw data? Are snapshot and merge
replication different in this regard?

Thank you,
terris

Hi Terris,

You can control whether indexes are copied to the subscriber with the
initial snapshot through the article schema options. The default schema
options for merge articles include more indexes than their
transactional\snapshot counterpart and this may account for the difference
that you are seeing. Note that SQL2000 cannot automatically replicate
indexes that are created after a snapshot is generated.

HTH

-Raymond

[quoted text, click to view]