Re: adding articles

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Paul Ibison wrote:
Saw this on Vyas's blog some time ago in SQL Server 2000
(http://vyaskn.tripod.com/sqlblog/).
As far as i know, you'll have to use a workaround eg have a different
publication publish the table.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .


Correct. I don't however see a work around posted here. I'm hoping
that someone might be able to clue me in to what I can do. I would
hate to think that MS would not have a way of adding the article to a
publication without having to do a total re-init.

-ms

.

Relevant Pages

  • Re: Cannot drop the table because it is being used for replication.
    ... On 2004-03-04, Paul Ibison wrote: ... collumns', click on 'add columnt to a table'. ... If you want to add a new table to publication - well, ...
    (microsoft.public.sqlserver.replication)
  • Re: adding articles
    ... I posted an unofficial workaround in the following posting: ... 'native' (which locks table during snapshot generation). ... Paul Ibison SQL Server MVP, ... publication without having to do a total re-init. ...
    (microsoft.public.sqlserver.replication)
  • Re: Error when adding a function to the articles
    ... Until now I didn't have any problems by putting tables, procedures and functions into one publication. ... If you alter a procedure or function you don't have to reinitialize the subscribers. ... You only have to generate a new snapshot when you add or drop a procedure or function. ... "Paul Ibison" schrieb im ...
    (microsoft.public.sqlserver.replication)
  • Re: replicate an indexed view
    ... >> with its own distribution agent for these types of object. ... >> Rgds, ... >> Paul Ibison ...
    (microsoft.public.sqlserver.replication)
  • Re: merge replication compatibility issue
    ... there were some pubs already created in 2005's level and I needed to ... recreate the publication. ... subscriptions to 2005 and I was able to add this new one back in. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)