InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 14:01:36 GMT20http://www.sqlservercentral.com/Forums/Topic360952-7-1.aspxYou must use sp_repladdcolumn if you do not want to reinitialize the publication.Fri, 27 Apr 2007 15:57:00 GMTJeremyEhttp://www.sqlservercentral.com/Forums/Topic360952-7-1.aspxThankyou. My publication is on sql2k and the subscriber is on sql2k5. I wish to insert column through scripts and sp_repladdcolumn might not work on different version of sql server. And before inserting a column do i have to drop subscription and the article that is published. Should i stop snapshot and distribution agent first. So what is the best way. EM or script. Fri, 27 Apr 2007 09:24:00 GMTkarina kapurhttp://www.sqlservercentral.com/Forums/Topic360952-7-1.aspx<P>Simple go to the replication properties and click on the <STRONG>'Filter Columns'</STRONG> tab. at the bottom u would get a button named '<STRONG>Add Column to table' </STRONG>when u click u r asked for the column name and the type also add NULL at the end because u cannot add a column with a not null constraint.</P><P>RegarDs,</P><P>JacX</P>Thu, 26 Apr 2007 22:22:00 GMTJerrinhttp://www.sqlservercentral.com/Forums/Topic360952-7-1.aspxIs this for transactional replication? If so, did you try to use sp_repladdcolumn with @force_reinit_subscription = 0. Books online (BOL) describe this as the way to disable the reinitialization (but I don't remember if it works in practice). See link below for info.http://msdn2.microsoft.com/en-us/library/ms189464.aspxThu, 26 Apr 2007 08:49:00 GMTOmri Bahat-433962http://www.sqlservercentral.com/Forums/Topic360952-7-1.aspx<P class=q nd="1">How can we add a column without having to reinitialize the entire publication. What is the procedure to do it?</P>Wed, 25 Apr 2007 12:33:00 GMTkarina kapur