Use osql redirecting output to a file

e.g.

osql - U login_id -d db_name -Q "query" -P password -S server_name >
c:\results.txt

Suggest you look osql up in BOL as there are numerous options.


> -----Original Message-----
> From: Shibu MB [SMTP:[Email Address Removed] Sent: Tuesday, November 26, 2002 6:00 AM
> To: LazyDBA.com Discussion
> Subject: output to a text file..
>
> Hi all
>
> How can i write the output of a quey to text file ??? Is there any
> utility
> for that ??
>
>
>
> Thanks
> Shibu
>
MS Sql Server LazyDBA home page