Adding Fields to a Replicated Database
Richard Waymire answers a reader’s question about replicating added and dropped columns in SQL Server 2000.
September 18, 2001
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.
About the Author
You May Also Like