sql server is double spacing all output

Ken Keller 1 Reputation point
2021-09-29T16:26:39.957+00:00

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.
12,707 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 101K Reputation points MVP
    2021-09-29T21:34:28.32+00:00

    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
  2. YufeiShao-msft 7,056 Reputation points
    2021-09-30T02:18:16.113+00:00

    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