deleting publications

Hi,
I created a few push subscriptions in continuous mode for testing
merge replication. I stopped the synchronization before I tried to
delete the publication. I got an error stating, can't delete because
the publication is being used for replication. I can't delete the
subscriptions on the subscriber as well. The tables associated with
the publications also can't be deleted. I don't want to use the Wizard
to delete all the publications.
Does anyone know how I can delete the publications?
Thanks!
PS.
PS,
try using sp_dropmergesubscription for each subscription, followed by
sp_dropmergepublication. Please report back the exact error message if there
is one.
When we can get the publication deleted: to ultimately drop the table you
can use a stored procedure to do this called sp_MSunmarkreplinfo which takes
a tablename as a parameter. Alternatively, running sp_removedbreplication
can be used to remove all traces of replication in the subscriber database,
but obviously must only be done if this database is not also configured as a
publisher.
HTH,
Paul Ibison
|||Hi,
I tried what you suggested and I got rid of the subscriptions and
publications.This is what I did:
I stopped synchronization, and deleted the publication entry under
Replication.
I then called sp_MSunmarkreplinfo to delete the table used for
replication.
On the subscriber however,
I had to delete the entries from 'sysmergearticles' and
'sysmergepublications' in order to delete the subscription entry under
'replication->subscriptions' and then call sp_MSunmarkreplinfo' to
delete the table.
Thanks for the help!
PS.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:<urzlrrQVEHA.584@.TK2MSFTNGP09.phx.gbl>...
> PS,
> try using sp_dropmergesubscription for each subscription, followed by
> sp_dropmergepublication. Please report back the exact error message if there
> is one.
> When we can get the publication deleted: to ultimately drop the table you
> can use a stored procedure to do this called sp_MSunmarkreplinfo which takes
> a tablename as a parameter. Alternatively, running sp_removedbreplication
> can be used to remove all traces of replication in the subscriber database,
> but obviously must only be done if this database is not also configured as a
> publisher.
> HTH,
> Paul Ibison

Deleting All Subscriptions

I have about a large number of subscriptions for ONE report that I would like
to bulk delete. Could you please advise if I could run an SQL query on the
database to achieve this? Due to the large number of subscriptions, I am
finding it impossible to delete the subscriptions thru the browser (by going
to the "Subscriptions" tab and ticking the "select all" button and clicking
"Delete". My browser keeps timing out). Hence, I am looking for an
alternative to delete from the backend. Please help. Thank you!I have managed to delete the subscriptions from the ReportServer database and
it has not caused any issues whatsoever.sql

Delete subscriptions

There are "orphaned" subscriptions on my server (Replication folder,
Subscriptions), how do I get rid of them? There are no publisher or
publications, referencing these subscriptions.
Thank you in advance.
Leon
My subscriptions are still there... despite the fact that there is no
publisher.
"Paul Ibison" wrote:

> These should help:
> http://technet.microsoft.com/en-us/library/ms146944(SQL.90).aspx
> http://technet.microsoft.com/en-us/library/ms146906(SQL.90).aspx
> Cheers,
> Paul Ibison
>
>