Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Viewing Database Size

Author  Topic  boz Starting Member 3 Posts Posted - 2001-12-14 : 12:08:57 When I double click on the Database it shows the data size is 3000mb and the data space available is 0mb when I run a sp_spaceused on that database the size is 820mb.How can I get the edit database window to correctly show how much data space is available.Is this a bug?Is there a script that I could run in to rectify this problem because I would prefer not to reboot the server or stop and restart the SQL server?I did a recalculate and then ran Checkpoint in the query window on the database as said by microsoft bug# 131349 for SQL enterprise manager displays 0 or negative size database for SQL V6.0/6.5 and it does not work still.Must I run the checkpoint on the database that I am having a problem with? Edited by - boz on 12/14/2001 12:27:49