Adding an existing column to replication

I have a table for which a subset of columns are being replicated. When I
want an additional column to be replicated, the GUI (publication properties
--> Filter Columns tab) alerts you that CHANGING THIS PROPERTY AUTOMATICALLY
MARKS FOR REINITIALIZATION ALL SUBSCRIPTIONS THAT SUPPORT AUTOMATIC
INITIALIZATION ...
Question:
1) How can I add the column without causing reinitalization to occur? I do
not want another snaphot to occur.
2) Will custom stored procedures be overwritten if the snapshot is not run?
Or will they have to be updated manually. Specifically, the original
stored procedure will only have N variables passed to it (for each of the
columns being replicated). Howerver after the change, the stored procedure
will require N+1 variables (for the new column that is added). Will the
new variable need to be added to the stored procedure manually?
*** Thanks in advance for your help ****
1) for transactional replication only the article will be re-snapshotted.
For merge the entire publication will be.
2) When you say custom procs, do you mean ones you have created yourself or
the replication stored procedures auto generated by SQL Server. If you mean
the later, yes they will be regenerated and will be corrected for the new
column. If you really do have custom replication stored procedures and have
disabled the autogeneration of the replication stored procedures they will
not be whacked, otherwise they will.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ziggy" <Ziggy@.discussions.microsoft.com> wrote in message
news:F96E8ECD-CA4D-4FB7-AD96-5402DB601135@.microsoft.com...
> I have a table for which a subset of columns are being replicated. When I
> want an additional column to be replicated, the GUI (publication
properties
> --> Filter Columns tab) alerts you that CHANGING THIS PROPERTY
AUTOMATICALLY
> MARKS FOR REINITIALIZATION ALL SUBSCRIPTIONS THAT SUPPORT AUTOMATIC
> INITIALIZATION ...
> Question:
> 1) How can I add the column without causing reinitalization to occur? I
do
> not want another snaphot to occur.
> 2) Will custom stored procedures be overwritten if the snapshot is not
run?
> Or will they have to be updated manually. Specifically, the original
> stored procedure will only have N variables passed to it (for each of the
> columns being replicated). Howerver after the change, the stored
procedure
> will require N+1 variables (for the new column that is added). Will the
> new variable need to be added to the stored procedure manually?
> *** Thanks in advance for your help ****
>