"Hassan" <fatima_ja@hotmail.com> wrote in message
news:#PKtwfyVDHA.2212@TK2MSFTNGP12.phx.gbl...
> I know that an existing article can be dropped and added to a subscription
> without deleting using sp_dropsubscription and sp_addsubscription as
opposed
> to the GUI
>
> My question is can i add a new table or sproc to the current subscription
?
> I am using SQL 2000
>
>
>

"Valerie Andersen (MSFT)" <vande@online.microsoft.com> wrote in message
news:uYiROx3VDHA.2568@tk2msftngp13.phx.gbl...
> Yes, you can add an incremental article. You can set
> @force_invalidate_snapshot = 1 when adding the new article so that a new
> snapshot is created after adding the incremental article.
>
> Valerie [MSFT]
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of any included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
>
>
> "Hassan" <fatima_ja@hotmail.com> wrote in message
> news:#PKtwfyVDHA.2212@TK2MSFTNGP12.phx.gbl...
> > I know that an existing article can be dropped and added to a
subscription
> > without deleting using sp_dropsubscription and sp_addsubscription as
> opposed
> > to the GUI
> >
> > My question is can i add a new table or sproc to the current
subscription
> ?
> > I am using SQL 2000
> >
> >
> >
>
>

"Valerie Andersen (MSFT)" <vande@online.microsoft.com> wrote in message
news:u#Qr7A6VDHA.1832@TK2MSFTNGP09.phx.gbl...
> Hassan,
> Upon reviewing the title of your original post, I realize I may have
> misunderstood your question. Do you want to add an additional, already
> published article to an already existing subscriber or are you looking to
> publish an additional article to an already existing publication?
>
> Thx,--
> Valerie [MSFT]
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of any included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "Valerie Andersen (MSFT)" <vande@online.microsoft.com> wrote in message
> news:uYiROx3VDHA.2568@tk2msftngp13.phx.gbl...
> > Yes, you can add an incremental article. You can set
> > @force_invalidate_snapshot = 1 when adding the new article so that a new
> > snapshot is created after adding the incremental article.
> >
> > Valerie [MSFT]
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > Use of any included script samples are subject to the terms specified at
> > http://www.microsoft.com/info/cpyright.htm
> >
> >
> >
> > "Hassan" <fatima_ja@hotmail.com> wrote in message
> > news:#PKtwfyVDHA.2212@TK2MSFTNGP12.phx.gbl...
> > > I know that an existing article can be dropped and added to a
> subscription
> > > without deleting using sp_dropsubscription and sp_addsubscription as
> > opposed
> > > to the GUI
> > >
> > > My question is can i add a new table or sproc to the current
> subscription
> > ?
> > > I am using SQL 2000
> > >
> > >
> > >
> >
> >
>
>

"Hassan" <fatima_ja@hotmail.com> wrote in message
news:uOvMTy6VDHA.2476@tk2msftngp13.phx.gbl...
> Publish an additional article to an existing publication and then add it
to
> a subscritption without deleting the subscription first 'cos i do not want
> to disturb the replication of existing articles
>
>
> "Valerie Andersen (MSFT)" <vande@online.microsoft.com> wrote in message
> news:u#Qr7A6VDHA.1832@TK2MSFTNGP09.phx.gbl...
> > Hassan,
> > Upon reviewing the title of your original post, I realize I may have
> > misunderstood your question. Do you want to add an additional, already
> > published article to an already existing subscriber or are you looking
to
> > publish an additional article to an already existing publication?
> >
> > Thx,--
> > Valerie [MSFT]
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > Use of any included script samples are subject to the terms specified at
> > http://www.microsoft.com/info/cpyright.htm
> >
> > "Valerie Andersen (MSFT)" <vande@online.microsoft.com> wrote in message
> > news:uYiROx3VDHA.2568@tk2msftngp13.phx.gbl...
> > > Yes, you can add an incremental article. You can set
> > > @force_invalidate_snapshot = 1 when adding the new article so that a
new
> > > snapshot is created after adding the incremental article.
> > >
> > > Valerie [MSFT]
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > Use of any included script samples are subject to the terms specified
at
> > > http://www.microsoft.com/info/cpyright.htm
> > >
> > >
> > >
> > > "Hassan" <fatima_ja@hotmail.com> wrote in message
> > > news:#PKtwfyVDHA.2212@TK2MSFTNGP12.phx.gbl...
> > > > I know that an existing article can be dropped and added to a
> > subscription
> > > > without deleting using sp_dropsubscription and sp_addsubscription as
> > > opposed
> > > > to the GUI
> > > >
> > > > My question is can i add a new table or sproc to the current
> > subscription
> > > ?
> > > > I am using SQL 2000
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>