Turn off display of header dashes in SQL Server Management Studio query results?

ssms

17,168

Goto Tools, Options, Query Results. You can change the output to Grid if you want there. I don't see a way to turn off just the dashes in the Results to text options. Check that - change to Comma Delimited and the dashes don't show up.

17,168

Author by

John K

Defining quotes: "The present letter is a very long one, simply because I had no leisure to make it shorter." — Blaise Pascal "The early bird gets the worm, but the second mouse gets the cheese." —Steven Wright "And yet what are we to do about this terribly significant business of other people." — Philip Roth

Updated on November 20, 2022

Comments

John K over 1 year
How can I tell SQL Server 2008 Management Studio to turn off printing of header dashes when displaying text results in a query window?

Examples of header dashes being produced are:

selectId, count(*) ContentCount from Table group by Id order by count(*) desc produces:
```
Id                   ContentCount
-------------------- ------------------
622                  5
623                  1
```
select 'Person Info' produces:
```
------------
Person Info
```
Those dashes are not conducive to all situations so I expect there is way to turn them off.
- Oded over 13 years
  
  Nit pick - this is not a "SQL Server" feature. It is a "SQL Server Management Studio" feature.
- John K over 13 years
  
  Looks like this is still the right place for this question meta.stackexchange.com/questions/70544 and FAQ says software tools commonly used by programmers stackoverflow.com/faq I changed the question tag from SQL Server to Management Studio.
John K almost 12 years

I don't want to get rid of the headers though, only the dashed delimiters.
Marcel Flygare almost 4 years

Please add a code block with the correct syntax. The answer will be improved and helpful.