Cannot DROP PROCEDURE ''duplicate_in_combolists'' because it is being referenced by object ''combolists_unique''.

• vision59

  SSCrazy

  Points: 2601

  More actions

  March 3, 2005 at 5:51 pm

  #85269

  How to resolve this problem!

  Cannot DROP PROCEDURE 'duplicate_in_combolists' because it is being referenced by object 'combolists_unique'.

  Thanks in advance

• March 7, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Melissa Kadiri

  Default port

  Points: 1435

  More actions

  March 8, 2005 at 12:04 pm

  #545979

  Save a copy of combolists_unique somewhere, drop it & then drop duplicate_in_combolists. 

  Modify the stored proc to remove the referenced dependency (or fix up the table and recreate it), then put back the sproc.

  Regards, Melissa