Good day,
I am having a problem running some scripts on a database which is no longer setup for replication. The database itself used to be setup for transactional replication. However, the database was moved to a new server and replication was not enabled. So, now when we try to run scripts we get the following
Msg 3724, Level 16, State 2, Server OPTACCEPT2, Line 3
Cannot drop the procedure 'dbo.sp_i_note' because it is being used for
replication.
The publisher and subscription server no longer exist.