In testing (learning?) I added a table to a database after a publication was
created. Then I went to modify that publication but the new table didn't
show up in the list of articles. But when I did this with a view it did show
up. Is there something about new tables that prevents them from showing up
in the wizard? What if I use sp_addarticle?
Bob
Bob,
there's a checkbox in the publication properties, articles tab which allows
you to see unpublished articles - please can you check to see if it is this
that is preventing you from seeing the new table.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Yeah, that was checked. But I've since deleted the publication. Thanks.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:epbCqnMrFHA.1252@.TK2MSFTNGP09.phx.gbl...
> Bob,
> there's a checkbox in the publication properties, articles tab which
> allows you to see unpublished articles - please can you check to see if it
> is this that is preventing you from seeing the new table.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment