Msg 3724, Level 16, State 2

  • 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.

     

     

     

     

  • do you have the latest sp installed?

    did you try to do a subscription and publisher clean up?

     

  • 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