Wednesday, March 28, 2012

Index replication in SQL Server 2000

Hello.
I am using an MS SQL Server 2000 with service pack 3.
How can I replicate indexes with EM replication wizard?
Is it possible in snapshots , merges and transactionl replications?
Thank you so much.
Have a look at the snapshot tab of the article properties - there is a
checkbox for clustered and non-clustered indexes.
Rgds,
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