How To Calculate Database Size In Sql 2000

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rahul manglik
    New Member
    • Sep 2006
    • 1

    How To Calculate Database Size In Sql 2000

    Hi , one of my database in SQL 2000 grew very inorganically , almost from 1.5 GB to 4 GB in one month . Is there a way i can find out which table is taking how much space in it .

    Regds
    Rahul Manglik
  • ramasp
    New Member
    • Sep 2006
    • 19

    #2
    Hi,

    In the Enterprise Manager
    ---------------------------------------
    1.select database
    2.Right click->View->taskpad
    3.In Taskpad, select table info

    Regards,
    Ram ASP

    Comment

    Working...