SIZE of tables in DB

• go2vish

  Old Hand

  Points: 303

  More actions

  October 9, 2008 at 5:59 am

  #127956

  Hi,

  Can anyone help me? I need get the size of all tables in the database.

  Is any query or sp is there which can give the result.

  I can get the size of each table individually by using "sp_spaceused 'table name'" but as the DB is huge and containg the 500+ table its a tedious task to carry.

  Please help as soon as possible.

  Thanks

  Vishwajeet

• Luke L

  SSC-Dedicated

  Points: 35545

  More actions

  October 9, 2008 at 6:17 am

  #882829

  This question was already asked and answered here http://qa.sqlservercentral.com/Forums/Topic583230-146-1.aspx.

  Please do not cross post.

  Thanks.

  -Luke.

  To help us help you read this[/url]For better help with performance problems please read this[/url]