In TSQL 2008 R2 I can't copy results without headers. I have checked the settings in Options>Query Results; Results to Grid and Results to Text both have the 'Include column headers in the results set' unticked. Despite this when I right click on the results pane and just choose Copy I still get the headers, makes no difference. A small but very irritating niggle. Ideas welcome.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
In TSQL 2008 R2 I can't copy result
- Thread starter feltonam
- Start date
DBRookie61370
Programmer
In the results window, click the box in the upper left corner highlighting all results, right click on the results within the window, and then select save results as and you're set!! I select csv and it works every time.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question