run series of scripts

• smknox

  Hall of Fame

  Points: 3275

  More actions

  September 17, 2005 at 9:28 am

  #187599

  I have about 40 or 50 scripts to run on my database, one of which is causing all records in one table to be deleted. To speed up the process of elimination of which script is the culprit, how can I run some but not all the scripts? Last time this happened I individually loaded the scripts in QA and ran each in sequence, taking several hours. There must be a quicker way.

  Thanks,

  Sam

• Jo Pattyn

  SSC-Dedicated

  Points: 32420

  More actions

  September 17, 2005 at 9:34 am

  #590798

  Starting the profiler and tracing for any delete / truncate table / drop table statements?

• Ian Goethert

  Say Hey Kid

  Points: 691

  More actions

  September 17, 2005 at 11:08 am

  #590799

  One trick I've used is save all the scripts in a folder and use the Windows Search "Containing Text" option.  As above; search for delete, truncate, drop, alter, etc.