How to copy non clustered indexes in transactional replication
4
votes
1
answer
4509
views
I create transactional replication ,but forget to include non clustered indexes and now my subscriber have only clustered indexes (primary key) and I want to transfer all nonclustered indexes to subscriber.Based on this answer http://www.sqlservercentral.com/Forums/FindPost1325516.aspx is good idea to script all non clustered indexes on publisher and then execute it on subscriber or is there another way which is better ?
Asked by GeoVIP
(263 rep)
Jul 27, 2015, 10:22 AM
Last activity: Sep 18, 2023, 11:09 AM
Last activity: Sep 18, 2023, 11:09 AM