I have a database which replicates out to 4 international sites, normally fairly successfully. However, the software provider has released an upgrade including changes to the schema. The update script fails as it can not drop some of the view's / procedures because they are being used for replication.
Server: Msg 3724, Level 16, State 2, Line 325
Cannot drop the view 'dbo.V_XXXXXXXXX' because it is being used for replication.
Server: Msg 3724, Level 16, State 2, Line 1
Cannot drop the procedure 'dbo.SP_ZZZZ' because it is being used for replication.
I have stopped the replication, deleted subscribers and disabled the publisher. How can I get rid of the remaining traces of replication so that I can upgrade the database (I presume there is probably a better way of doing this than killing all replication, but it's too late now!).
Thanks in advance for your help.