I am new in SQL server 2005. I had setup SQL server 2005 P2P and Transactional replication. Somehow it did not work correctly. 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.
Also, If I try sp_dboption[Database Name]. I get these rows returned.
auto create statistics
auto update statistics
I tried to use
@ignore_distributor = 1.
It says "database is not enable for publication"
I tried to enable publication (sp_dboption [database],'publication',true)
It says "database option publication does not exist"
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