sql server 2000 replication

itsonlyme4 used Ask the Experts™
I have a SQL Server 2000 Database that I cannot delete because it is being used for Replication (I believe it is a subscriber)
but I do not know which instance the Publisher is.  

Is there a way to remove the subscription (on the subscriber side) so I can drop this Database ?     This is all Dev so I'm not worried about breaking anything..
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Engineer
Distinguished Expert 2017
I don't have any SQL Server 2000 instance to guide you, but there isn't a Replication folder? If so, you should find the subscriber there and delete it.
I think in the Enterprise Manager menu you'll also find a option to remove the subscription.

I wouldn't swear to it but I believe you should be able to use SSMS from SQL Server 2005 to see what's going on. Maybe 2008 too


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial