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


Thank you.