Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Change field length w/ transac replication

Author  Topic  liga77 Starting Member 1 Post Posted - 2001-06-18 : 15:58:35 I have to modify field length in the table, which is part of publication. I tried to use an Enterprise Mgr and received an error message because that table is scheduled for replication. Is any way around this beside temporary stopping and restarting replication? And actually how to do this to be sure that after restart the data will be again in sync. We have transactional replication, SQL Server 2000 Enterprise Edition and Windows 2000 Advanced Server. Thanks,