Problem with saving results grid to a file

vgeier · May 21st, 2007, 02:02 PM

I cannot get the Query Analyzer to save the column titles when saving the results grid to a text file. Is there a way to change this?

Thanks

happygv · May 28th, 2007, 06:43 AM

Try with BCP utility. From Query analyser you can copy/save the column headers, if you dont mind with the data formatting, change to TEXT mode and try to copy/paste into a text file.

_________________________
- Vijay G
Strive for Perfection

Jeff Moden · June 1st, 2007, 11:42 PM

If you really want to do it from query analyzer, change the result options to "TAB DELIMITED" and use the Text mode of Query Analyzer, instead.

--Jeff Moden