Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2005
    Posts
    3

    Unanswered: Finding Table , Database size

    Hii all,

    I want to find the database , table size in MS SQL Server.

    Is there is any query /procedures to find out the database and table size.

    Thanks in advance .,

    Regards.,

    Sri

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Database Size :
    sp_helpdb [ [ @dbname= ] 'name' ]

    Table Size :

    sp_spaceused [[ @objname = ] 'objname' ] [,[ @updateusage = ] 'updateusage' ]
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Sep 2005
    Posts
    3
    Quote Originally Posted by Enigma
    Database Size :
    sp_helpdb [ [ @dbname= ] 'name' ]

    Table Size :

    sp_spaceused [[ @objname = ] 'objname' ] [,[ @updateusage = ] 'updateusage' ]

    Thanks for ur answers .

    I already started using sp_spaceused for DataBase and sp_show_huge_tables
    for table .

    Sri

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    I already started using sp_spaceused for DataBase and sp_show_huge_tables
    for table .
    sp_show_huge_tables ... WTH did this come from ???
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Jun 2005
    Posts
    50

  6. #6
    Join Date
    Jun 2005
    Posts
    50
    sp_show_huge_tables uses spt_values table..
    any idea where can i get more info??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •