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.

Voila