February 27, 2006 at 2:03 pm
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.
March 2, 2006 at 12:17 am
do you have the latest sp installed?
did you try to do a subscription and publisher clean up?
March 2, 2006 at 8:36 pm
how are you trying to drop the SP?
try dropping it through QA,
------------------------------
Life is far too important to be taken seriously
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply