Option to Copy (without headers) gone??

Question

I am using SSMS 2008 R2 (Version 10.50.4000.0). As of this week, I can no longer copy my results without headers. My settings are Results to grid and I have double-checked that under Tools -> options my Query Results, Results to Grid does NOT have the option "Include column headers when copying or saving the results" checked.

When I right click in my result set, I still see both options; "Copy" and "Copy with Headers". No matter which when I use, I get column headers when I paste into Excel. I do this every week and this is the first time this has happened. (I did get updates this morning.)

Is this happening to anyone else??

Answer 1

Hi,

According to your description, I do a test in SQL Server 2008 R2 (version 10.50.4000.0), everything works well. I copy my query results without headers, and paste the data into Excel successfully. Below is my setting of Tools/options in SQL Server. Please restart the SQL Server Management Studio (SSMS) after you change the following settings.

Thanks,
Lydia Zhang

Answer 2

Hi,

MY ssms version is (10.50.4263) I just checked and it works as expected. When I do "Copy" i do not get the headers and when I do "Copy with Headers" i do get the headers as expected.

I have same settings as you mentioned.

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

Answer 3

It seems that if you create a new query window it will behave as specified in the options.

BUT if you right click a table in object explorer and choose 'SELECT TOP 1000 ROWS' it creates a query with the 'include headers when copying' option checked. (ignoring the option settings).

(SSMS version 13.0.16106.4)

Answer 4

Please update to a current version of SSMS:

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Answer 5

Updated to the current version 17.9.1 (14.0.17289.0)

Same behavior.

Selecting 'SELECT TOP 1000 ROWS' creates a query with the option to copy headers enabled, ignoring the option settings.

Answer 6

v18.3.1 (15.0.18183.0)

Confirmed, still the same behaviour.

Answer 7

I have same issue. Changed my options to include column headers when copying. Exited from SQL and restarted it.

I still cant copy with headers.

Answer 8

Here is how i resolved the issue:

what ever query you were running - click SQL button on the command bar

copy your SQL script into New Query

Run the query 

now right click on the result set - you will have the option to Copy with header or saving it to external folder

Thanks