Size of a value in NTEXT field

[PghMikeH]

We have an application that stores MS word documents in an NTEXT field. Suddenly, this table has grown exceptionally large. Is there a way to determine the size of that NTEXT column for each row? By knowing which documents are large, we can then find the template that is causing the huge growth.


Mike Hillwig
mike@hypermike.com

http://www.hypermike.com

I've done more R5 deployments than I care to think about.

 

[yelworcm]

Look up the datalength() function in BOL. You may need to divide by two, for the N, but it should all be there.