sql server is double spacing all output

Ken Keller 1 Reputation point

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,805 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 78,026 Reputation points MVP

    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?

    0 comments No comments

  2. YufeiShao-msft 6,986 Reputation points

    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”)

    0 comments No comments