Table Size

  • In EM select the Database then choose task pad view and then select Table Info tab and you will see tables sizes.

    Which system table is that stored in?


    Kindest Regards,

  • It's stored in sysindexes, although that number isn't always up to date.  Take a look in BOL for the system stored procedure sp_spaceused for the recommended way to retreive that data.

    -Eddie

    Eddie Wuerch
    MCM: SQL

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply