<div>
this is the longest header in result pane. Q2NonTireMotorcraftTestedT<wbr />oughBatter<wbr />y
</div>


this is the longest header in result pane. Q2NonTireMotorcraftTestedToughBattery

<div>
and column header no space and no &quot;_&quot; , no special characters.
</div>


and column header no space and no "_" , no special characters.

<div>
SSMS options--&gt;query results--&gt;SQL server--&gt; resultstogrid--&gt;check include headers
</div>


SSMS options-->query results-->SQL server--> resultstogrid-->check include headers

ss.bmp

<div>
Hi roshnipatel, I had same you showed, but still not come out.
</div>


Hi roshnipatel, I had same you showed, but still not come out.

<div>
Then you should go to Query -&gt; Results To -&gt; results to text.<br />
Re-execute your query.<br />
<br />
You'll be prompted to select a file location. &nbsp;If you choose .rpt, once the query has ran, change the file extention to .csv<br />
<br />
You should have the headers that way
</div>


Then you should go to Query -> Results To -> results to text.
Re-execute your query.

You'll be prompted to select a file location.  If you choose .rpt, once the query has ran, change the file extention to .csv

You should have the headers that way

<div>
Because it's results to grid like I indicated earlier, thats the default so I assume thats what your doing.
</div>


Because it's results to grid like I indicated earlier, thats the default so I assume thats what your doing.

solved.png

<div>
<div class="content wysiwyg-content">
Hi Expert,<br />
<br />
When I export to csv file from sql server 2008 resoult pane, it lost header, how to solve the problem. I right click on result pane and select to 'save results as' csv file.<br />
<br />
Thanks in advance.<br />
<br />

</div>
</div>


Hi Expert,

When I export to csv file from sql server 2008 resoult pane, it lost header, how to solve the problem. I right click on result pane and select to 'save results as' csv file.

Thanks in advance.



lost header when export to csv file from sql server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.