"Hilary Cotter" wrote:

> Try sp_repladdcolumn
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> 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
>
>
>
> "Rich" <Rich@discussions.microsoft.com> wrote in message
> news:21B350DC-DA4A-4C97-81E8-18EFA16BC329@microsoft.com...
> > Hello,
> >
> > I appologize in advance if this question is way too lame, but I have this
> > transactional snapshot respication job, and here are a few lines of the
> > sql
> > from the generate sql window from the properties of the replication job
> > ---------------------------------------------------------------------------------------
> > -- Enabling the replication database
> > use master
> > GO
> >
> > exec sp_replicationdboption @dbname = N'Subscriber', @optname =
> > N'publish',
> > @value = N'true'
> > GO
> >
> > use [Subscriber]
> > GO
> >
> > -- Adding the transactional publication
> > ...
> > --------------------------------------------------------------------------------------
> >
> > I need to add 2 columns to the table that is under replication at the
> > publishing end and at the subscriber end. That's easy. So the generate
> > sql
> > window shows all the current columns of the replicated table. Can I
> > modify
> > that sql from the properties window to include the 2 new columns? I am
> > guessing probably not.
> >
> > May I ask the procedures to perform this operation? Do I need to disable
> > replication, add the columns to the article and then re-enable
> > replication?
> >
> > I can post the sql code for this job if required (about 2 pages worth of
> > sql).
> >
> > Any suggestions greatly appreciated.
> >
> > Thanks,
> > Rich
> >
>
>