Hi,
I want to add a table/article that I have removed before some days because
of some problems.
Since I'm using transactional replication with "nosync" initialization I
don't know how can I add to the replication one article.
Thanks, BaniSQL
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
"BaniSQL" <BaniSQL@.discussions.microsoft.com> wrote in message
news:43C3C933-A02A-4CDE-BA94-5748AF588365@.microsoft.com...
> Hi,
> I want to add a table/article that I have removed before some days because
> of some problems.
> Since I'm using transactional replication with "nosync" initialization I
> don't know how can I add to the replication one article.
> Thanks, BaniSQL
>
|||What page number?
"Hilary Cotter" wrote:
>
> --
> 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
>
> "BaniSQL" <BaniSQL@.discussions.microsoft.com> wrote in message
> news:43C3C933-A02A-4CDE-BA94-5748AF588365@.microsoft.com...
>
>
|||Have a look at the sp_addsubscription stored procedure. You can pass a
single article name in the article parameter or use 'ALL' for all articles
in your publication.
"BaniSQL" <BaniSQL@.discussions.microsoft.com> wrote in message
news:4E2398B7-8664-472F-B264-30EB47043375@.microsoft.com...[vbcol=seagreen]
> What page number?
> "Hilary Cotter" wrote:
Thursday, February 9, 2012
Adding an article with no-sync initialization
Labels:
adding,
article,
becauseof,
database,
initialization,
microsoft,
mysql,
no-sync,
oracle,
replication,
server,
sql,
table,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment