Post reply

Howto remove publication from the publisher when its removed from the database

  • September 10, 2008 at 6:13 am

    #99264

    Hi.

    I'm using merge replication on ms sql 2000 and replicate data with PDA. In the list of publications in the replication monitor I have my XXX publication, but in the database publication list it doesn't appear. The snapshot agent also exists. When I try to delete this publication from publisher list (in repl monitor) I got the error 21776. When I try to use sp_droppublication I got the error that object syspublications doesn't exists.

    How can I fix this. I only want to remove all publications from this database.

    Thanks in advance.

  • September 12, 2008 at 9:17 am

    #871071

    Can you remove replication totally from that server or will that break other publications ?

    Graeme

  • September 16, 2008 at 8:18 am

    #872404

    I haven't tried it. I'm afraid of loosing it. The server is working all the time and publicating lots of data, so I don't want to risk to much.

  • September 16, 2008 at 8:43 am

    #872431

    You will have to look in the publication table for the database and you will probably find the related record still showing there. You should be able to delete that and things will clear up.

    Orphaned records, not always fun to deal with.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • September 18, 2008 at 5:41 am

    #873516

    Where can I find this table?

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

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