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@127.0.0.1.activesol.co.uk> wrote in message
news:caWdnYudXqARsRHeRVnyuA@pipex.net...[color=blue]
> <mr.nitinjain@gmail.com> wrote in message
> news:1133252435.378052.52860@g14g2000cwa.googlegro ups.com...[color=green]
>> 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!!![/color]
>
> 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
>
>[/color]
