Is there a way to automaticatly save a sql result to a file?

[kenworld]

Example:

Select * from TEST_TBL
result are saved to a file called text
c:\test.txt

 

[GRHE]

Try this

declare @str varchar(100)
select @str = 'isql -Q "set nocount on
SELECT * from TEST_TBL" -o\\test.txt'
exec master..xp_cmdshell @str

also have a look at the many params of isql

enjoy..............