How can I get Management Studio 2005 to copy the headers from result sets?

Question

By default when you copy/paste data from a query window in SSMS it does not copy the column headings. How can I get these headers to be copied along with the data?

Answer 1

1. Open Tools menu
2. Open Options...
3. Expand Query Results
4. Expand SQL Server
5. Expand Results to Grid
6. Check Include column headers when copying or saving the results

Note that this will only work on the "New Query" types of windows -- not the "Open table" (editable) windows.

Answer 2

Results with headers was added in SSMS 2008. Ctrl-Shift-C works as well.