sp_spaceused in SQL6.5
Posted on 2000-05-15
SQL 6.5 sp5a
Database size: 12 G.
DB devices used: 12 (1 G each)
I have a database which has some sizing inconsistencies. In Enterprise Manager, under database, when I click on the properties, it indicates 0 bytes available.
So, what I did was added db device of 1 G size and attached the db to them to increase the space. Did it twice but still to no avail.
Then I ran the sp_spaceused and sp_helpdb to determine the properties of the db. I found that the available space as indicated by the sp_spaceused query shows more than 2 G available.
I have run dbcc update_usage but the database still shows 0 bytes available in the Enterprise Manager.
What could be wrong with the SQL database?