Tom Carnahan (1/19/2010)
Would either of you know what BOL is talking about when it says that for SS2K, the max row length is 8060 bytes? I clearly saw that by using ntext, I could go way beyond that.
The max row length is 8060. Text, ntext and image columns are stored 'out of row'
It's like saying that only x letters can be written on an A5 page, but you can say "see file cabinet 54 for more info" and 'point' at far more than could be stored on the page.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability