Prevent SSMS changing tab to space when copying text from Result Tab

Question

SSMS 2016 changing tabs to spaces when copying from Result Tab (does not matter ctrl+c or drag&drop). For example if execute this code

SELECT 'a' + CHAR(9) + 'b'

then copy text from result tab and paste in any editor it will be space instead tab between 'a' and 'b' characters.

How to prevent this behaviour?

P.S.: Saving result to CSV working properly and saving tab (code 9). Error caused only on copying.

score 3 · Accepted Answer · answered Jul 13 '16 at 08:31

3

Go to Options and check Retain CR/LF on copy or save.

answered Jul 13 '16 at 08:31

Paweł Tajs

2

I've checked but no result. Still space instead tab. – Andrey Jul 13 '16 at 08:34
2

Close existing tab and open new one. – Paweł Tajs Jul 13 '16 at 09:14
That's a completely unintuitive option if the goal is retaining tabs!! (Not your fault, of course...) – RonJohn Jun 15 '20 at 07:03
Or use SSMS and Output to Text? – MT1 Mar 27 '24 at 09:30

1 Answers1