Prev: Duplicate columns across 4 columns
Next: Connection Status
From: Lam Nguyen on 17 Jul 2008 12:05

I have a db which about 417 gb, after I did some archives and truncate bunch
of tables. I was able to save some spaces but still showing 417 gb on GUI.
Is there a command that I need to run to show free spaces. Thanks.

Here is the information when I run the sp is return correct but the gui is
not showing correrct info. SQL 2000.
Thanks in advance.

All tables in the MyCompanyDB database.
All numbers in MB except the Rows column.

Data space : 459409.6 MB
Database Log space : 12000.0 MB
Total Database size : 471409.6 MB

Space used by all table data : 172870.3 MB
Space used by all table indexes : 19774.6 MB
Space used by data and indexes : 192644.8 MB
 | 
Pages: 1
Prev: Duplicate columns across 4 columns
Next: Connection Status