Post reply

run series of scripts

  • 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

  • September 17, 2005 at 9:34 am

    #590798

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

  • 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.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply