I have a query that returns a large 'ntext' result. I want to copy this over to a plain text editor (Notepad), but only a part gets copied over.

I tried increasing Query Options -> Results -> Text, but the max seems 8192, which is insufficient for me.

Any ideas on how this can be achieved?

I'm using SQL Server Management Studio 2008, if that matters.

TIA! Raj

sql-server-2008 ssms
Edit
Report