• By default, I believe results to text only outputs the first 255 characters or so. Go to Tools >> Options, Expand Query Results, Expand SQL Server, and Highlight Results to Text. There you will see the option "Maximum number of characters to display". Set that to like 2000 and you should see everything.