Hi

3 ways that i can think of now are

1) Use SSIS

2) IN mgmt studio - select Query\Results\ResultstoText and then copy paste the output to a textfile.

3) IN mgmt studio - select Query\Results\ResultstoFile.

In this case Query\QueryOptions\Results tab check

"Include column headers when copying or saving results".