sql server is double spacing all output

Question

I installed SQL Server 2019 over a year ago. Just in the past week it has started generating all output as double spaced. This happens when I load a stored procedure into the editing window and also when I try to export output from the grid to Excel. Where is the option to turn off double spacing.

Answer 1

What double spacing? SQL Server does not print any data - it only returns data on the TDS channel for the client to format.

Possibly this is an issue in SSMS (which is not SQL Server), but it does not ring a bell. Can you post a screenshot to demonstrate the issue?

Answer 2

Hi @Ken Keller ，

You can try to do like this:
When you run stored procedure or others, set Result to text
(Query->Results to ->Results to text, shortcut CTRL+L)

You may need to increase the maximum number of characters per line in Results to text
(Tools->Options->Query Results->SQL Server->Results to text->set “maximum number of characters displayed in each column”)