Post reply

Dropping publication

  • December 2, 2003 at 6:05 am

    #101782

    Hi, I'm running SQL 2000 sp3 on win2000. I have 5 subscriptions. I had to dropped them. 4 dropped fine, but one timeout. Right now the publisher thinks there are no subscriptions. When I go to the server that timeout. I look in the publications folder I see the publication. How can I delete it.

  • December 16, 2003 at 6:14 am

    #486375

    Hey Marck

    Got same problem over here. Already have a solution ?

    thx

    Jeff

    JV


    JV

  • December 24, 2003 at 10:41 am

    #487784

    Not sure, but how about using sp_droppullsubscription first to get rid of the orphan subscription, then maybe you can drop the publication ? (Either through EM or manually via sp_droppublication)

Viewing 3 posts - 1 through 3 (of 3 total)

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