>OK, just out of curiousity, what is the largest ntext value that you have? You can use the DATALENGTH() return the amount of data in a column: > I've tried to run this query:
SELECTMAX(DATALENGTH(textcolumn)) FROM thetable
And got error message:
Server: Msg 7102, Level 20, State 99, Line 1
SQL Server Internal Error. Text manager cannot continue withcurrent statement.
Connection Broken