How to execute a sql script from another script?

• rxm673

  Grasshopper

  Points: 11

  More actions

  March 6, 2003 at 1:54 pm

  #81708

  I need to execute mulitple SQL script from a main SQL script. How can this be accomplished ? I need to execuet the main script from Query Analyzer?

  Thanks

• bpdavis

  SSC Rookie

  Points: 45

  More actions

  March 6, 2003 at 2:01 pm

  #450464

  You can put the scripts in stored procedures and then issue multiple EXEC <stored proc name> commands from the Query Analyzer.

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  March 6, 2003 at 2:09 pm

  #450466

  Another method is to can call xp_cmdshell from within your sql code to execute a OSQL command that runs each script.

  [/quote]

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP