I am using SQL Server 2000. I had a problem where a stored procedure is messed up and I want to overwrite it. Howerver the database is replication all through the network. I have not removed everything for replication that I can find and I am still unable to delete that stored procedure. The message I get is unable to drop the procedure "procedure" it is being used for replication.
I have removed all traces of replication that I can find but it still says under Replication Subscriptions that it has a subscripton. When I try to delete the subscription it tells me the publication or the subscription do not exist. How do I get this replication stuff out of there so I can rebuild my stored procedures? This is very frustrating. i will award multiple question points for this if I have to. Please Help!!!!!