Post reply

Adding Index to replicated table

  • December 9, 2008 at 7:13 am

    #196895

    Hey, I need to add an index to an already established push subscription database table. I know when you make a schema change to an existing replication, you have to break the replication, modify the table structure, rebuild the replication, re-instantiate(word?) the subscription. So, if I add an index will I have to go through all of these steps?

    I think I know the answer, just hoping I am wrong.

    Thanks

    Bill 😀

  • December 10, 2008 at 1:25 am

    #910121

    Creating indexes does not use an ALTER Table statement so you should be fine.

    Graeme

  • December 10, 2008 at 6:35 am

    #910287

    Thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply