Query output to file?

[Gooser]

Is there an easy way to output a query to a file? The query will eventually be in a stored procedure that will be run once per day and I need the results of the query to be in a file. Can I do this without using DTS? Any help greatly appreciated, as usual.



v/r

Gooser

Why do today
that which may not need to be done tomorrow --me

The Universal Model

 

[memdiscount]

Hi;

Read my blog article

http://www.tsql.ca/Resources/EssasBlog/tabid/633/EntryID/35/Default.aspx

Or read this article from here:

http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx

You might need to fix temp table error.

I have been using this function in production successfully.

Thanks