Is there anyway of programmatically outputting the results from a select
query straight out to a file.

I am looking for a purely programmatic way that runs automated and not
through job scheduling etc.

Kind Regards

Paul,

You can use -osql or -isql command (see BOL for more details):

exec master..xp_cmdshell 'osql -E -Q"select * from table" -o"C:\output.txt"
'



Richard

"Paul Bull" <bull53 (AT) bull53 (DOT) karoo.co.uk> wrote