Executing a SQL script via VB

• sramayah

  Grasshopper

  Points: 13

  More actions

  May 7, 2003 at 11:24 pm

  #80022

  Hi!

  At the moment, I'm creating a script runner with VB6 and SQL-DMO that will run all SQL scripts in a folder.

  Is there anyway I can execute a script file without opening the script file itself?

  Been trying to find a class method in SQL-DMO that will do the bloody job for me....

  Please help.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 8, 2003 at 3:14 am

  #456495

  I know of no way as you have to open the file to read the contents.

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  May 8, 2003 at 3:34 am

  #456499

  Would the isql/osql dos commands do this for you? I have never used them but BOL suggests that you can execute a query file (script file?) from a dos prompt.

  Jeremy