SQLServer 2005 Replication - Pause or Disable

clogau_gold used Ask the Experts™
We have an SQL Server (2005) setup to be both a Publisher and Distributer. One of the databases on there is replicated to another database off site (a small subset of the data).
If I wish to make a schema change to the on site database, I am unable to as there is replication set up on table. This makes sense and I have no problems with this. However, to make any schema change, I am currently having to delete the whole Publication, make the change, and then recreate the Publication from scratch.
Is there a way I can pause/disable the existing replication to allow me to change the structure of a table and then unpause/enable to continue rather than having to delete and recreate the Publication?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I'm a bit rusty on replication, but could you not stop the distribution agent, amend your schema, regenerate your publication to pick up the new schema and then push this onto your subscriber?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial