Copying column headers with grid query results in SQL Server Management Studio


Many times when we are copying result from the Result Set GRID, column headers are not copied with it. To copy the column header you have to enable it.

Go to Tools menu -> Option -> Query Results -> SQL Server -> Results to Grid -> Checked the “Include column headers when copying or saving the result” check box

Thanks for the comment, will get back to you soon... Jugal Shah