RE: Error creating new push subscription after deleting the existi
- From: v-rxwang@xxxxxxxxxxxxxxxxxxxx (William Wang[MSFT])
- Date: Thu, 11 Aug 2005 11:45:54 GMT
Yes, it's possible. The correct steps are listed in the BOL topic "How to
Delete a Push Subscription (Transact-SQL)" or the KB article 324401 (How to
manually remove a replication in SQL Server 2000
http://support.microsoft.com/?id=324401):
To drop a push subscription to all articles for a transactional
publication, run the following script at Publisher:
USE <<Publication database name>>
GO
EXEC sp_dropsubscription @publication = N'<<Publication name>>', @article
= N'all', @subscriber = N'all', @destination_db = N'all'
Or you can use the Enterprise Manager:
At the Publisher, open SQL Server Enterprise Manager, expand a server
group, expand the Replication folder, expand the Publications folder, click
the publication that has the subscription you want to delete, right-click
the push subscription for that publication in SQL Server Enterprise
Manager, and then click Delete.
Subscription information at the Subscriber will not be deleted, and you
should delete it manually. But there is no need to delete the jobs.
Since you have deleted all the jobs and some of them are replication jobs
that are not specific to any subscription, the current configured
replication has been broken and you need to rebuild them. To do so, first
disable Publishing and Distribution: In SQL Server Enterprise Manager,
expand a server group, expand the Distributor, right-click the Replication
folder, and then click Disable Publishing.
Feel free to let me know if you have any other concerns.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
.
- Follow-Ups:
- References:
- Error creating new push subscription after deleting the existing o
- From: Charts
- RE: Error creating new push subscription after deleting the existing o
- From: William Wang[MSFT]
- RE: Error creating new push subscription after deleting the existi
- From: Charts
- Error creating new push subscription after deleting the existing o
- Prev by Date: Re: Global update of multiple tables
- Next by Date: Re: Global update of multiple tables
- Previous by thread: RE: Error creating new push subscription after deleting the existi
- Next by thread: RE: Error creating new push subscription after deleting the existi
- Index(es):
Relevant Pages
|
Loading
