Hi,
I have set up a transaction replication. I tried to remove the subscription.
I deleted the subscription using EM in the repliaction properties, even then
when I go back and see the subscription server, I still see the subscriptions
out there. I have a distributor in which the replication happens. Can some on

EM does a lot of caching. Right click on the subscriptions folder and select
refresh. You can also try to delete them here as well.

If there are still there try to delete them from the system tables in the
subscriber database(MSreplication_subscriptions, MSsubscription_agents), and
in the distribution database (MSsubscriber_info, MSsubscriber_schedule,
MSsubscriptions). Be careful what you delete, you can whack active
subscriptions.

--
Hilary Cotter
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

[quoted text, click to view]