Applying New Index to Replicating Table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Applying New Index to Replicating Table

Hi Guys, Applying New Index to Replicating TableI really need your help on this, I have 3 databases that are replicating. I want to apply new indexes to certain tables, do i still need to re-do the replication setup? Thank
Serge
Not required to redo the setup. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thank you very much Satya. Btw, so I will just create the script that will update my 3 database(table)indices and apply it to them?<br /><br /><br />More power![<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]
BTW, what is the version of SQL used? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
We are using SQL Server 2000 Enteprise Ed. for the Main Server(Win 2003) while the other two remote servers is Personal Edition running on Win2k.

As far as I’m aware, you’d have to create the indexes manually on all 3 databases Cheers
Twan
Yes as specified execute’em manually on involved database/tables.
As its SQL 2K no need to refresh the replication setup for any changes occured on the table(s). Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>