This Blog Article was brought forward from my old blog
Time for some tips about how to use the SQL Server Management Studio. This is a really great tool which should be more used by NAV DBA’s.
First tip is how to include column headers when copying query results. This is something we often use when analysing systems remotely.
When opening the management studio goto – tools – options
Then select – Query Results – SQL Server – Results to Grid
And select “Include column headers when copying or saving the results”.
After this, the column headers from the query results are copied to the clipboard and pasted into MS Excel.