Database Size Issue

[grimmy]

I am currently running SQL 6.5 and have a database setup with a 1GB data size. At this minute there is only 200MB free but there is not a lot of data in tables in this database that changes so I cannot believe that it is using 800MB.
What is the best way of seeing how much data size an individual table/object is taking.

Cheers....Paul.

 

[SQLBill]

I've never used 6.5, so I don't know if this will work for you....but in SQL 2000 you can use

exec sp_spaceused

and/or

exec sp_spaceused 'table_name'

the first gives you the information for the database and the second for the specified table.

-SQLBill