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.

Voila

Advertisements
This entry was posted in Tips and Tricks. Bookmark the permalink.

2 Responses to Tip #1 :SQL Management Studio – Include Column Headers

  1. Pingback: Tip #50 – Implementing Addresses | Brummel Dynamics Services B.V.

  2. Pingback: Tip #50 – Implementing Addresses - Microsoft Dynamics NAV Community

Leave a Reply

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 )

Google+ photo

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

Connecting to %s