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