don't want to replicate non-clustered indexes | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

don’t want to replicate non-clustered indexes

Is there a way not to replicate existing non-clustered indexes in transactional replication? I don’t want to replicate the indexes to make the snapshot distribution go faster. When the snapshot is initialized, it copies all indexes that already exists on the publication table. There is an option not to copy the non-clustered index in the snapshot tab, but it’s being grayed out.
Follow:
-At the Publisher, start SQL Server Enterprise Manager.
-Expand a server group, and then expand a server.
-Expand Databases, and then expand the name of the database where the Distribution Agent fails.
-Expand Publications.
-Right-click a publication, and then click Properties.
-On the Publication Name Properties dialog box, click the Articles tab.
-In the Specify the objects to publish as articles list, double-click the article that the error -occurred for.
-In the Article Name Properties dialog box, click the Snapshot tab.
-Under Copy Indexes, click to clear the Copy nonclustered indexes to the subscription table check box, and then click OK.
-On Publication Name Properties dialog box, click OK.
-Click Yes on the Save changes dialog box.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>