Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    26

    Angry Unanswered: Publisher cannot be droped becaused Remote Distributor down

    Hi all,

    I am having a problem now. I cannot drop my publisher and publication because i was uninstalled the remote distibutor before i disable al lthe publication. Now the remote distibutor no longer exist.

    Can another one help me? Urgent!!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't know of any way to remove replication using the GUI tools in the situation you've described, but it can be done fairly easily using Transact SQL stored procedure calls. Check out sp_droppublication and pay special attention to the @ignore_distributor parameter. Microsoft normlly recommends that you use this only with the help of their PSS group, but your data may not be worth $750 to open a support incident with them, so you may choose to "go it alone" instead of calling them for help.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •