Re: Drop an article through EM

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

From: "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx>
Date: Mon, 27 Feb 2006 17:08:29 -0000

Sammy,

it's possible but only through scripts eg:

exec sp_dropsubscription @publication = 'tTestFNames'
, @article = 'tEmployees'
, @subscriber = 'RSCOMPUTER'
, @destination_db = 'testrep'

exec sp_droparticle @publication = 'tTestFNames'
, @article = 'tEmployees'

Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

.

Prev by Date: Transactional replication from SQL Server 2005 to SQL Server 7 - how?
Next by Date: Re: Quiescing Replication
Previous by thread: Re: Drop an article through EM
Next by thread: Transactional replication from SQL Server 2005 to SQL Server 7 - how?
Index(es):
- Date
- Thread

Relevant Pages

Re: default objects and replication
... why not initialize just based on the table eg if your table was tEmployees ... exec sp_dropsubscription @publication = 'tTestFNames' ...
(microsoft.public.sqlserver.replication)
Re: Running ALETR scripts on Transaction Replication
... exec sp_dropsubscription @publication = 'tTestFNames' ... alter table tEmployees alter column Forename varcharnull ...
(microsoft.public.sqlserver.replication)
Re: Adding an article to Publication
... exec sp_addsubscription @publication = 'tTestFNames' ... run the snapshot agent and the ...
(microsoft.public.sqlserver.replication)
Re: adding existing column to an existing replication
... exec sp_dropsubscription @publication = 'tTestFNames' ... Paul Ibison SQL Server MVP, ...
(microsoft.public.sqlserver.replication)
Re: Replication - adding new articles
... exec sp_dropsubscription @publication = 'tTestFNames' ... Paul Ibison SQL Server MVP, ...
(microsoft.public.sqlserver.replication)