Hi.

In EM, if you had run a Query, you were able to copy also the Column-headings (and paste them into say Excel).

Does anyone know if this is possible also in SQL Management Studio? And if so, how to do it?

Gert

create a new query and select the results to file option

"Results to File" is best, but you can also select "Results to Text" option and that will allow you to copy and paste the query results, including the column headings.

Thanks for your replies.

Allthough these are good sugestions, it seems to me that if I want the info into Excel, it doesn't work just as I need it too. In excel all the row data ends up in the first cell. I need the seperate columns to end up in seperate columns also in excel.

Gert

First ensure that Tools, Options, Query Results, SQL Server, Results to Grid, has the check next to Include to column headings when copying or saving the results.

Then run your query in Grid mode, then right click the grid and select Save As, then save it as a csv. Open the CSV in excel and you will have the column headings

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

Thanks ALOT David. This is just what I was looking for...

It also works with copy/paste into Excel.

:-)

Gert