With SQL Server 2008 R2, when I save the results as a CSV there are no headers. I can work around this by copying and pasting with the "Copy with Headers" , or just grab the headers and paste them in the CSV etc, but is there a better way to do this?
Welcome to Database Administrators Stack Exchange

Database Administrators is a question and answer site for database professionals. It's built and run by you as part of the Stack Exchange network of Q&A sites. With your help, we're working together to build a library of detailed answers to every question about database administration.
We're a little bit different from other sites. Here's how:
Ask questions, get answers, no distractions
This site is all about getting answers. It's not a discussion forum. There's no chit-chat.
Just questions...
...and answers.
Good answers are voted up and rise to the top.
The best answers show up first so that they are always easy to find.
The person who asked can mark one answer as "accepted".
Accepting doesn't mean it's the best answer, it just means that it worked for the person who asked.
Save Results as CSV *with* headers in SSMS
2 Answers
In SSMS you need to change some options:
Tools - Options - Query results - sql server - results to grid (or text) -> Include column headers when copying or saving the results.
You could do a union all join.
You earn reputation when people vote on your posts
Your reputation score goes up when others vote up your questions, answers and edits.
As you earn reputation, you'll unlock new privileges like the ability to vote, comment, and even edit other people's posts.
Reputation | Privilege |
---|---|
15 | Vote up |
50 | Leave comments |
125 | Vote down (costs 1 rep on answers) |
At the highest levels, you'll have access to special moderation tools. You'll be able to work alongside our community moderators to keep the site focused and helpful.
2000 | Edit other people's posts |
---|---|
3000 | Vote to close, reopen, or migrate questions |
10000 | Access to moderation tools |
Get answers to practical, detailed questions
Focus on questions about an actual problem you have faced. Include details about what you have tried and exactly what you are trying to do.
Ask about...
- Database Administration
- Advanced Querying
- Data Modelling and database-design
- Advanced Programming in built-in server-side languages
- Data Warehousing and Business Intelligence
Not all questions work well in our format. Avoid questions that are primarily opinion-based, or that are likely to generate discussion rather than answers.
Questions that need improvement may be closed until someone fixes them.
Don't ask about...
- Anything not directly related to database administration
- Questions that are primarily opinion-based
- Questions with too many possible answers or that would require an extremely long answer
Improve posts by editing or commenting
Our goal is to have the best answers to every question, so if you see questions or answers that can be improved, you can edit them.
Use edits to fix mistakes, improve formatting, or clarify the meaning of a post.
In SSMS you need to change some options:
Tools - Options - Query results - sql server - results to grid (or text) -> Include column headers when copying or saving the results.
Unlock badges for special achievements
Badges are special achievements you earn for participating on the site. They come in three levels: bronze, silver, and gold.
Student | Asked first question with score of 1 or more |
Editor | First edit |
Good Answer | Answer score of 25 or more |
Civic Duty | Voted 300 or more times |
Famous Question | Asked a question with 10,000 views |
Find a question to answer, or ask your own
Database Administrators Stack Exchange is part of the Stack Exchange network
Like this site? Stack Exchange is a network of 103 Q&A; sites just like it. Check out the full list of sites.
Use comments to ask for more information or clarify a question or answer.
You can always comment on your own questions and answers. Once you earn 50 reputation, you can comment on anybody's post.
Remember: we're all here to learn, so be friendly and helpful!