August 19, 2008 at 7:57 am
I have a database that was replicated, but the replication has been removed after some corruption problems. I have deleted all subscriptions and publications etc, and have run the sp_removereplication procedure, but there are still some items hanging over from the replication
I have had to manually remove the insert/update/delete triggers from the replicated tables, but there are a lot of system stored procedures, all beginning sp_ins_XXXXXXXX or sp_upd_XXXXXX (XXXXX is a long hex string) which I can't drop.
I have tried changing the "allow modifications to be made directly to the system catalog" setting on the server, tried dropping them from stored procedures, tried changing their attributes to stop them being system objects etc, but I still can't get rid of them!
Can anyone suggest anything else?
August 19, 2008 at 10:14 am
Try using sp_droppublication(if publication still exists), sp_dropsubscriber and sp_removedbreplication stored procedures on publisher.
MJ
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply