Trans repl distr agent not deleting -- sql server replication

Chris
9/7/2006 3:47:02 PM

SQL2000 sp4 trans repl

I executed

sp_dropsubscription @publication = 'MyPub'
, @article = 'ALL'
, @subscriber = 'MYSUBSCSVR'

I still have a distribution agent sending data to this subscriber for MyPub?
Went to EM, clicked on pub at publisher, do not see server in subscr list.

Ran profiler on subscriber, seeing data replicating.

How do I clear the distribution agent at remote distributor?

tia,
chris

Hilary Cotter
9/7/2006 10:16:14 PM

In your subscription database issue this command
sp_MSenumsubscriptions
and then try to drop it again with the subscription info given.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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]

sql server replication : Trans repl distr agent not deleting