Dropping User Stored Procs

• sqlSushi

  Mr or Mrs. 500

  Points: 516

  More actions

  December 29, 2003 at 3:44 pm

  #161015

  Hi,

  I am copying data from one SQL Server to another via DTS copy objects task.

  Though I have enabled Drop Destination Objects first in the DTS task, objects in the destination are not being dropped and the DTS fails, due to the objects already existing in the destination.

  Does anyone know a quick way to drop these destination Stored Procs?

  Thanks!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738632

  More actions

  December 31, 2003 at 10:18 am

  #488383

  select * from sysobjects where type = 'proc' and then run this in a cursor with exec( drop procedure xx) in the loop./

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net

• sqlSushi

  Mr or Mrs. 500

  Points: 516

  More actions

  January 2, 2004 at 10:05 am

  #488497

  Thanks,

  Worked great!