in SQL 2008 R2 - Go to Tools - Options
left hand side Query Results - SQL Server - Result to Grid
select 2nd check box to the right - Include Column Headers when copying or saving the results
this will always copy grid data with headers.
commented on Aug 30 2011 9:22AM