Help - Error deleting publication or adding subscription

In the haste of trying to delete a publication/subscription combo, it looks
as if it's stuck in limbo. I must have done something out of sequence.
In Microsoft SQL Server Management Studio it appears the subscription on the
secondary server has been deleted yet I can't delete the publication as it
says it can't delete the subscription. When I try to add the subscription on
the second server it says it already exists, even though It doesn't list
itself under subscriptions.
I'm trying to remove all replication and I'm wondering if it needs to be
deleted manually through the database as something is out of sync.
Thanks
Ron
If this is a push subscription issue the following
sp_dropsubscription @.publication= 'PublicationName', @.article= 'ALL',
@.subscriber= 'SubscriberName'
, @.destination_db= 'SubscriptionDatabase', @.ignore_distributor = 0If this
does not clear it up do thissp_dropsubscription @.publication=
'PublicationName', @.article= 'ALL', @.subscriber= 'SubscriberName'
, @.destination_db= 'SubscriptionDatabase', @.ignore_distributor = 1Then
check your subscription database. See if there are entries in the tables
MSreplication_subscriptions and MSsubscription_agents for this publication
and delete the entries if they exist.-- http://www.zetainteractive.com -
Shift Happens!
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
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:AB12955C-2B1C-4C1A-9D11-7F47D8FB6A29@.microsoft.com...
> In the haste of trying to delete a publication/subscription combo, it
> looks
> as if it's stuck in limbo. I must have done something out of sequence.
> In Microsoft SQL Server Management Studio it appears the subscription on
> the
> secondary server has been deleted yet I can't delete the publication as it
> says it can't delete the subscription. When I try to add the subscription
> on
> the second server it says it already exists, even though It doesn't list
> itself under subscriptions.
> I'm trying to remove all replication and I'm wondering if it needs to be
> deleted manually through the database as something is out of sync.
> Thanks
> Ron
|||Thanks Hillary,
Before i saw your reply I executed the following and it worked:
EXEC sp_droppublication @.publication = N'xxxxxxx'
go
USE master
GO
EXEC sp_replicationdboption @.dbname = N'xxxxxxx',
@.optname = N'publish', @.value = N'false'
"Hilary Cotter" wrote:

> If this is a push subscription issue the following
> sp_dropsubscription @.publication= 'PublicationName', @.article= 'ALL',
> @.subscriber= 'SubscriberName'
> , @.destination_db= 'SubscriptionDatabase', @.ignore_distributor = 0If this
> does not clear it up do thissp_dropsubscription @.publication=
> 'PublicationName', @.article= 'ALL', @.subscriber= 'SubscriberName'
> , @.destination_db= 'SubscriptionDatabase', @.ignore_distributor = 1Then
> check your subscription database. See if there are entries in the tables
> MSreplication_subscriptions and MSsubscription_agents for this publication
> and delete the entries if they exist.-- http://www.zetainteractive.com -
> Shift Happens!
> 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
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:AB12955C-2B1C-4C1A-9D11-7F47D8FB6A29@.microsoft.com...
>
>