Post reply

Table Size

  • November 27, 2007 at 1:31 am

    #62198

    i want to calculate total size of a table in kbs or in mbs

    is there any in-built function available??

    or ant other way to do this?

  • November 27, 2007 at 1:59 am

    #754417

    Hi Suchita,

    sp_spaceused 'tablename'

    Regards,

    Ahmed

  • November 27, 2007 at 2:36 am

    #754431

    thx for ur reply

  • November 27, 2007 at 3:20 am

    #754451

    Displaying disk space information about a table

    sp_spaceused

    Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or SQL Server 2005 Service Broker queue in the current database, or displays the disk space reserved and used by the whole database

Viewing 4 posts - 1 through 3 (of 3 total)

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