unable to copy binary string from table to notepad
in SQL Server Management Studio, go to the &quot;Tools&quot; menu, click on &quot;Options&quot;, then navigate to &quot;Query Results&quot;, &quot;SQL Server&quot;, &quot;Results to Grid&quot;, and modify the &quot;Non XML data&quot; option to whatever setting you desire.

Aaron has a great post about how to chunk output so you can see it all, regardless of how large a piece of text you're dealing with at MSSQLTips
However, in SSMS 18, I am able to get substantially larger amounts of text to copy-and-paste from the results window using the option I detailed above.  There are at least a couple of caveats you might need to know about before it starts working.

After you change the &quot;Maximum Characters Retrieved&quot; for Non-XML Data, it only takes effect for new query windows.  i.e. you must open a new query window before you can get more than 65535 characters to copy-and-paste.

If you are testing this by generating a series of characters with replicate, ensure you use an explicit &quot;max&quot; data type, as in varchar(max) or varbinary(max).  If you run SELECT REPLICATE('X', 131072) for example, the resulting string will only be 8,000 characters in length because the implicit conversion is to a varchar type, not a varchar(max) type.  Running this, however, will generate a string that is 131072 characters in length:
SELECT [string] = REPLICATE(CONVERT(varchar(max), 'X'), 131072)
    , [length] = LEN(REPLICATE(CONVERT(varchar(max), 'X'), 131072))

The results:



I modified the &quot;Maximum Characters Retrieved&quot; value to 131072, then opened a new query window and pasted in the code above, hit F5, and got the results you see above.  I then cvopied the value shown in the &quot;string&quot; column to the clipboard, then pasted it into another new query window, where I confirmed the length of the string with the following code:
SELECT LEN(CONVERT(varchar(max), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX(due to the 30,000 character limitation on questions,  not all the &quot;X&quot;s are shown here) XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))

╔══════════════════╗
║ (No column name) ║
╠══════════════════╣
║           131072 ║
╚══════════════════╝