Adding an Index to a table which is being merge replicated

  • Hi,

    I'm using SQL Server 2005 SP2.

    Is it possible to add a new index to a table which is being merge replicated or do you have to remove replication, add the index and then configure replication again?

    Thanks in advance.

    Stephen

  • In general for replication, Index can be dropped and/or created any time any where (Publisher or subscriber). You cannot drop and recreate a primary key though.

    -Roy

  • Hi Roy,

    Thanks for the reply.

    Yes, it's only a non-clustered index with 2 column composite key.

    Cheers,

    Stephen

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

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