>A little but annoying thing. Is there any way to set Query Results to "File" or "Text" in a script?
>Googling has not turned up anything.
>
> I know I can do it in SSMS, but I would like to be able to just set it in my scripts.
>
>Thanks

Try using FOR XML PATH(char(13)).

Check this blog
http://bradsruminations.blogspot.com/2009/10/making-list-and-checking-it-twice.html

Alternatively using BCP check the idea from How to script all stored procedures in a database the very bottom of the blog.