Tip #1 :SQL Management Studio – Include Column Headers

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.


Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.