How can I make changes to my Publisher tables e.g change columns ,

I have a transactional replication with one publisher and one subscriber.
This is working fine. Now my developers need to make changes to the
production database. They would like to change columns, add new indexes, etc.
What is the bet way to do this without much down time?
George Gopie
freaking developers. You can use sp_repladdcolumn or sp_repldropcolumn for
changing columns. To add new indexes use sp_addscriptexec for subscriptions
deployed via unc's.
If your environment's schema is volatile (i.e. changing all the time) you
should look at log shipping or SQL Server 2005.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"georgeg" <ggg@.hotamil.com> wrote in message
news:B980F6D1-CF64-4A7D-B513-9715D427A898@.microsoft.com...
> I have a transactional replication with one publisher and one subscriber.
> This is working fine. Now my developers need to make changes to the
> production database. They would like to change columns, add new indexes,
etc.
> What is the bet way to do this without much down time?
> --
> George Gopie
>