Msg 3724, Level 16, State 2

• jlane-305769

  Valued Member

  Points: 73

  More actions

  February 27, 2006 at 2:03 pm

  #89640

  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.

   

   

   

   

• Jen-169507

  Right there with Babe

  Points: 776

  More actions

  March 2, 2006 at 12:17 am

  #624200

  do you have the latest sp installed?

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

   

• adamcrv

  Hall of Fame

  Points: 3056

  More actions

  March 2, 2006 at 8:36 pm

  #624514

  how are you trying to drop the SP?

  try dropping it through QA,

  
  ------------------------------
  Life is far too important to be taken seriously