indexing replicated tables

• Sherri

  SSC Enthusiast

  Points: 168

  More actions

  November 15, 2005 at 1:51 pm

  #90818

  I am currently using merge replication on two servers.  I would like to add an index to one of the tables being replicated.  What is the best way of doing this?  Can I just add it to the individual servers?

• Chris Becker

  SSCrazy

  Points: 2645

  More actions

  November 16, 2005 at 6:54 pm

  #604330

  Yes - you will have no problems adding or deleting indexes to replicated tables.

  ChrisB MCDBA OCP MyDatabaseAdmin.com

  Chris Becker bcsdata.net

• rangark

  Right there with Babe

  Points: 738

  More actions

  November 17, 2005 at 1:19 am

  #604360

  Remember  to create the index at respective databases (Publiser and subscriber servers)