sql server replication: When you create your publication articles you can indicate that if the table
already exists, leave it alone (instead of DROPping it). This allows you
more freedom to do things on the subscriber but it also introduces some
complexity because now you need another mechanism to update the schema if it
changes. Take a look in Enterprise Manager under the publication
properties, pick an article and click the properties button and view the
Snapshot tab. Also lookup sp_addarticle.

Mike

[quoted text, click to view]

Is there anyway to modify indexes also permissions on replicated tables for
SQL2000
Transactional replication.
Every time snapshot agent runs and refreshes the table all of the indexes
are replaced from source table and also permissions