Sample Header Ad - 728x90

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