>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.
>


You have to run your script from one of SQL Server command-line utilities like BCP or SQLCMD (2005 and later).