I am new in SQL server 2005. I had setup SQL server 2005 P2P replication. Somehow it did not workÃÂ one of two way replication. I tried to delete the publication. However I could not do it.ÃÂ have the same problem. When I tried to delete the publication, I got the publication " " does not exist.[SQL server error: 20026]. I tried to use sp_droppublication, it gave me error "the database is not enabled for publication". Nevertheless, I can see the publication in MS SQL Management Studio and Publication monitor with OK status.ÃÂ I could not find the distribution database either.
Could you anyone has ideas to delete this publication? I am sorry I am not a programmer. Please give me more detail explanation if you can. Thanks.
View Complete Post