Text Datatype.

• Mkumari

  Hall of Fame

  Points: 3498

  More actions

  April 3, 2002 at 10:18 am

  #63812

  Hi,

  could any one tell me if i execute the sp_spaceused store proc against a table does it include the space occupied by a

  textcolumn.

  Thanks,

  roo[

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 3, 2002 at 10:58 am

  #426546

  I think it includes the size of the pointer, or the bytes if using the text in row option.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 3, 2002 at 4:01 pm

  #426563

  This may still apply with 7 and 2000 but not sure. Check out http://support.microsoft.com/default.aspx?scid=kb;EN-US;q90758

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)