sp_spaceused provides information about the space used for text data as index_size:
sp_spaceused blurbs
name rowtotal reserved data index_size unused --------------- -------- --------- ------- ---------- ------ blurbs 6 32 KB 2 KB 14 KB 16 KB
