After exporting sql grid results (or copy and paste in Excel) - Header is missing. How do I export (or copy) the column titles?

Posted on 2008-06-23
Last Modified: 2010-04-16
After the sql query runs, when I copy and paste (or export to .csv) results in Excel - the header doesn't come with it.  How do I get the header to copy over?
Question by:glabossi
  • 3
  • 2
LVL 60

Accepted Solution

chapmandew earned 500 total points
ID: 21847001
in management studio, to go tools, options, query results, sql server, results to grid...make sure the option is checked to include column headers.

Author Comment

ID: 21847058
THe funny thing is that it is already set like this?  I still can't get the headers!
LVL 60

Expert Comment

ID: 21847073've got me then.
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.


Author Comment

ID: 21847171
Darn.  Me too!  It should be obvious that that would do it but I still get no headers!  I'm in SQL 2005 Query Analyzer.
LVL 60

Expert Comment

ID: 21847205
Thats really wierd....its always worked for me....

Expert Comment

ID: 22116800
From MSSMS go to  QUERY---QueryOptions--Grid then CHECK on the 'Include column headers when copying or saving results'

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now