Will this force a reinitialize in Merge Replication Topology?

Posted by Refracted Paladin on Stack Overflow See other posts from Stack Overflow or by Refracted Paladin
Published on 2010-03-17T12:02:05Z Indexed on 2010/03/17 12:51 UTC
Read the original article Hit count: 446

Filed under:

I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint coulumn or a part of any article filters and it allows NULL. I have a pretty good idea that I can run this --> ALTER TABLE tblPlanDomain ADD ReportWageES VARCHAR (100) NULL

and NOT force all my clients to reinitialize but I was hoping for some reassurance. Can anyone verify this one way or the other for me?

Thanks,

Will this force a reinitialize in Merge Replication Topology?

Posted by Refracted Paladin on Server Fault See other posts from Server Fault or by Refracted Paladin
Published on 2010-03-17T11:26:45Z Indexed on 2010/03/17 11:31 UTC
Read the original article Hit count: 446

Filed under:

sql-server

|

replication

|

merge-replication

|

sql-server-2005

I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint coulumn or a part of any article filters and it allows NULL. I have a pretty good idea that I can run this --> ALTER TABLE tblPlanDomain ADD ReportWageES VARCHAR (100) NULL

and NOT force all my clients to reinitialize but I was hoping for some reassurance. Can anyone verify this one way or the other for me?

Thanks,

Developer IT