How to export delimited (tab, space, comman) file from query analyzer Visual Management Studio (2005)
In the Query menu choose Query options
1. From Results Choose Text
2. Choose out format from drop down list
3. Click OK.
4. In the query menu from Result to choose Result to file
5. Run your query it will ask you the file name and by default it shows in save as type [Report files (*.rpt)]
6. Choose All files (8.*) from save as type drop down.
7. Name your fiel as “myfil.csv” and click on save.
