David,

Actually there is a way to get the column names from the grid view in Sql Server Management Studio.

Goto:

Tools|Options|

+Query Results

+SQL Server

Results to Grid

Check the checkbox (Include column headers when copying or saving the results)

Peter