Cannot drop subscription

• Nelson Viggiani-332216

  Ten Centuries

  Points: 1264

  More actions

  November 30, 2006 at 9:01 am

  #95015

  SQL Server 2000,

  I create 3 replications from server A to server B (both sql server 2000)

  after while we don't need anymore, so I delete from the Publisher, I did from enterprise manager

  right click and delete, but it wont' delete on subscriber (don't know why)

  so How I delete from the subscriber? right click wont' work there

  sp_drosubscription wont' work says :

  The remote server is not defined as a subscription server.

  any ideas?

  thanks

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 1, 2006 at 9:47 pm

  #675322

  Try running sp_removedbreplication procedure.

  Read BOL for details.

   

  MohammedU
  Microsoft SQL Server MVP