Getting object sizes in a database

• schwizla

  SSCrazy

  Points: 2668

  More actions

  September 21, 2006 at 9:51 am

  #170432

  o knowledgable ones...

  I have a extremely large database and would like to know the easiest and most informative way of retrieving all objects and their sizes on a given database. I would especially be interested in tables and how many rows/how large each one is.

  thanks in advance

• Sreejith Sreedharan

  SSCertifiable

  Points: 5403

  More actions

  September 21, 2006 at 9:58 am

  #661804

  You can use Enterprise Manager.

  Select the Database->View->Taskpad. Then on the Right plane Click on Table Info

  You can use sp_spaceused procedure to do one object at a time.

  Thanks

  Sreejith