Re: LOAD .SQL file

I dont know if this is an option for you, but can you make a DTS package
with sql statements task?
Then you can execute DTS package from command prompt using dtsrun utility.

MC


"Brian Cryer" <brianc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:caWdnYudXqARsRHeRVnyuA@xxxxxxxxxxxx
> <mr.nitinjain@xxxxxxxxx> wrote in message
> news:1133252435.378052.52860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Hi dear members,
>> Can onyone please tell me that how can we load multiple files/ or even
>> a single .SQL file stored on any physical location(Hard Disk) from SQL
>> prompt.
>> i have written some scripts in diffrent files, now i want to run those
>> scripts, Do i always need to manually open those scripts and run it on
>> query analyser or is there some way out.
>> Please HELP!!!
>
> I'm sure there is an easier way (and I genuinely look forward to someone
> telling me), but I use .cmd scripts which call osql passing the sql script
> I want. That way if I want to run half a dozen scripts I need half a dozen
> calls to osql in my .cmd file each of which gets passed one of my sql
> scripts.
>
> Hope this helps.
> --
> Brian Cryer
> www.cryer.co.uk/brian
>
>


.

Relevant Pages

  • Re: creating unique index and clustered index in sql server management studio
    ... Anything more should be done thru the Generate Scripts ... Andrew J. Kelly SQL MVP ... > SQL 2000 GUI created the indexes by creating a constraint while the new ... >>> Then the changes work and the code is genereted in the scripts. ...
    (microsoft.public.sqlserver.tools)
  • Re: Help Understanding mx.ODBC Error
    ... running the scripts on old data (that these scripts were able to digest ... Greg Corradini wrote: ... But recently they continue to bail on the mycursor.execute('An SQL ... Sent from the Python - python-list mailing list archive at Nabble.com. ...
    (comp.lang.python)
  • Re: Help Understanding mx.ODBC Error
    ... Greg Corradini wrote: ... I wrote two scripts using mx.ODBC on an Access DB. ... But recently they continue to bail on the mycursor.execute('An SQL ... I used the proper parameterization with "?" ...
    (comp.lang.python)
  • Index server not displaying results (random directories)
    ... strictly the SQL statement and the directory and write DESC ... to display files in a certain directory with extra parameters like ' ... filename like "01 04" added to the SQL and write DESC ... yet the scripts and directory structures and filenames are ALWAYS ...
    (microsoft.public.inetserver.indexserver)
  • Re: LOAD .SQL file
    ... > a single .SQL file stored on any physical locationfrom SQL ... > i have written some scripts in diffrent files, now i want to run those ... but I use .cmd scripts which call osql passing the sql script I ... That way if I want to run half a dozen scripts I need half a dozen ...
    (comp.databases.ms-sqlserver)