DJC,
you can use sp_addscriptexec to replicate index changes.
HTH,
Paul Ibison

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

just putting out a feeler on this since I think I am about to be asked to do
this.

Can I add/remove indexes on replicated tables? If so, will that schema
change replicate to subscribers (sql server 2000 subscribers)?

I have used the sp_repladdcolumn stored procedure. Hopefully there is one
for indexes as well?

any info is appreciated. Thanks.

Thanks Paul. I'll checkout sp_addscriptexec in sql server books online.

I appreciate the direction.


[quoted text, click to view]