SQL Server 2000 Replication

• Jpotucek

  SSCoach

  Points: 18583

  More actions

  October 5, 2015 at 12:27 pm

  #100593

  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..

• JeremyE

  SSCoach

  Points: 16199

  More actions

  October 5, 2015 at 2:36 pm

  #1831533

  Have you tried sp_removedbreplication?

  https://technet.microsoft.com/en-us/library/aa239336(v=sql.80).aspx