• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

How to copy the result in mangement studio in sql server 2005 to Excel along with its column names

I tried to copy the resultset in sql server2005 to Excel.but i could copy only the results not the column names.can anyone tell me How to copy the result in mangement studio in sql server 2005 to Excel along with its column names?
0
mshan
Asked:
mshan
1 Solution
 
chapmandewCommented:
go to tools, options, results...there is an option for copying column headers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now