Add a article to a Merge Replication

I have a Merge Replication with 48 subscriptions and I like add a new
article, but I don't like reinitialize all my subscriptions.
I try to use the sp_addarticle,
sp_addarticle [ @.publication = ] 'NamePublication'
, [ @.article = ] 'NameArticle'
, [ @.source_table = ] 'source_table'
but when I 'm running the sp it is send me this message
Server: Msg 208, Level 16, State 1, Procedure sp_MSreinit_article, Line 25
Invalid object name 'syspublications'.
can you query the syspublications table on your publisher?
Are all objects owned by dbo?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"David Barquero" <davbarquero@.hotmail.com> wrote in message
news:um0KPj$9EHA.3504@.TK2MSFTNGP12.phx.gbl...
> I have a Merge Replication with 48 subscriptions and I like add a new
> article, but I don't like reinitialize all my subscriptions.
> I try to use the sp_addarticle,
> sp_addarticle [ @.publication = ] 'NamePublication'
> , [ @.article = ] 'NameArticle'
> , [ @.source_table = ] 'source_table'
> but when I 'm running the sp it is send me this message
> Server: Msg 208, Level 16, State 1, Procedure sp_MSreinit_article, Line 25
> Invalid object name 'syspublications'.
>
|||I was getting very similar messages when I was modifying system stored
procedures and did not restored their original attributes.
I am not sure how it all works, but if you modify system stored procedure,
it's attributes (in sysobjects table) are changed - column 'status' and
'base_schema_ver' are updated by the system. You have to restore those
values to the state that was before applying your modifications.
For example you are modifying stored procedure sp_addmergearticle.
1. Before doing your modifications, select current data from sysobjects for
that stored procedure.
SELECT * FROM [master].[dbo].[sysobjects] WHERE name = 'sp_addmergearticle'
2. Do your modifications to sp_addmergearticle
3. Update sysobjects with values selected in the 1st step
UPDATE [master].[dbo].[sysobjects]
SET [status]=-1073741823,
[base_schema_ver]=16
WHERE name = 'sp_addmergearticle'
4. Enjoy your working (hopefully) replication
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"David Barquero" <davbarquero@.hotmail.com> wrote in message
news:um0KPj$9EHA.3504@.TK2MSFTNGP12.phx.gbl...
> I have a Merge Replication with 48 subscriptions and I like add a new
> article, but I don't like reinitialize all my subscriptions.
> I try to use the sp_addarticle,
> sp_addarticle [ @.publication = ] 'NamePublication'
> , [ @.article = ] 'NameArticle'
> , [ @.source_table = ] 'source_table'
> but when I 'm running the sp it is send me this message
> Server: Msg 208, Level 16, State 1, Procedure sp_MSreinit_article, Line 25
> Invalid object name 'syspublications'.
>
|||Please use sp_addmergearticle.
thanks - deepak
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"David Barquero" <davbarquero@.hotmail.com> wrote in message
news:um0KPj$9EHA.3504@.TK2MSFTNGP12.phx.gbl...
> I have a Merge Replication with 48 subscriptions and I like add a new
> article, but I don't like reinitialize all my subscriptions.
> I try to use the sp_addarticle,
> sp_addarticle [ @.publication = ] 'NamePublication'
> , [ @.article = ] 'NameArticle'
> , [ @.source_table = ] 'source_table'
> but when I 'm running the sp it is send me this message
> Server: Msg 208, Level 16, State 1, Procedure sp_MSreinit_article, Line 25
> Invalid object name 'syspublications'.
>
|||Great observation Somehow I missed the point that David was using
sp_addarticle instead of sp_addmergearticle
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"Deepak kumar [MSFT]" <dk@.online.microsoft.com> wrote in message
news:uQ3AnZQ$EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Please use sp_addmergearticle.
> thanks - deepak
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "David Barquero" <davbarquero@.hotmail.com> wrote in message
> news:um0KPj$9EHA.3504@.TK2MSFTNGP12.phx.gbl...
25
>