delete unwanted publications

  • we are running transaction replication, and when I create a replication somehow unwanted replication was created on my subscriber database without distributor and subscriber, now I try to delete but it didn’t work I am getting an error “could not find the Distributor “ and I can’t add the distributor.

  • check if dist.. database exist in system database or not?

    If in sql server 2005 or higher, check activity monitor. Might get some clue what process still running

    ----------
    Ashish

  • Thanks,

    I am running 2005 and did not have a distributor(distributor db) set up on that box, and I can not use that box as a distributor.

    I can't see the eplication monitor it says this server is not sys for publisher and distributor

  • i am not talking about replication monitor, i said activity monitor where you can see if any process is still running for replication

    ----------
    Ashish

  • Sorry,

    No processer is running for replication

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply