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


Thank you.