The table FTPsite is replicated from Server A to Server B. when I renamed a column of Test to MyTest by runnig sp_rename 'FtpSite.test','Mytest','COLUMN'; on server A. an error occur
Msg 15051, Level 11, State 1, Procedure sp_rename, Line 278 [Batch Start Line 7]
Cannot rename the table because it is published for replication.
The replication is set up to allow schema change. run the statement SELECT replicate_ddl FROM syspublications; it return 1.
This table has huge records. I don't want to take the table out from the replication, rename the column and add it back and take a new snapshot. How to rename the column without a new snapshot?