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

ssms

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.

Best Answer

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

enter image description here

Related Question