Drop procedure from other DB

• Mithrandir

  SSCrazy

  Points: 2628

  More actions

  May 3, 2006 at 8:14 am

  #113091

  Hello.

  I have a procedure to programatically restore a DB (datawarehousing), but I'm stuck...

  I have to drop a stored procedure from the restored database, but USE statements are not allowed in SPs, so I tryed db.owner.spname naming, but explicit DB naming is not allowed for DROP PROCEDURE statements.

  How can I get rid of that procedure?

• Scorpion_66

  SSCertifiable

  Points: 7891

  More actions

  May 3, 2006 at 1:09 pm

  #635760

  This is a case where dynamic sql is the only way......do a remote execute statement.....

  Execute Otherdatabase.dbo.sp_execute "Drop ....."

   

• Peter E. Kierstead

  SSCarpal Tunnel

  Points: 4114

  More actions

  May 4, 2006 at 8:42 am

  #635956

  Or...

  Exec('Use targetdbname Drop Table tablename')

  ---

  
  PeteK
  I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.

• Mithrandir

  SSCrazy

  Points: 2628

  More actions

  May 4, 2006 at 9:04 am

  #635977

  Great!

  Thanks for your help, it worked.