November 22, 2011 at 4:47 am
Can I add an index to a table in the Subscriber database where the index does not exist in the Publisher?
Thanks
November 22, 2011 at 5:08 am
This was removed by the editor as SPAM
November 22, 2011 at 5:58 am
Stewart "Arturius" Campbell (11/22/2011)
yes, you can.However, bear in mind that, whenever replication re-snapshot takes place, all manually added indexes will disappear.
You can add a post snapshot script to re-add the indexes in the event of reinitialising the subscriber.
Re-snapshoting on its own does not drop all objects. For example, you can add a new article to a subscription, generate a snapshot and only the new article will be generated.
November 22, 2011 at 6:20 am
That is a great help, it solves what could have been a big issue in a data load design i am doing
Thanks Again
Martin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply