Adding Fields to a Replicated Database

Richard Waymire answers a reader’s question about replicating added and dropped columns in SQL Server 2000.

Richard Waymire

September 18, 2001

1 Min Read
ITPro Today logo in a gray background | ITPro Today

My company's two offices, one in Arizona and the other in Nebraska, are connected by DSL. They both have SQL Server 2000 running on Windows 2000 Server, and the Nebraska database is replicated to the Arizona server. We need to add a couple of fields to one of Arizona's database tables, but when we try to make this change, the Nebraska server tells us we can't because the table is replicated. To add the fields, do we have to disable the replication?

SQL Server 2000 supports replicating added and dropped columns through the stored procedures sp_repladdcolumn and sp_repldropcolumn. Use these stored procedures instead of the usual ALTER TABLE ADD COLUMN command. In the next release of SQL Server, code-named Yukon, Microsoft hopes to add support for replicating other Data Definition Language (DDL) operations.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like