SQL Server Performance Forum – Threads Archive
why is the unallocated space a negative number
Hi there,I shrinked the transaction log last night. And after I did it, I used sp_spaceused to check the information. I noticed that the unallocated space is -3.89MB. How could that happen?
Check Space available in Enterprise Manager, if 0, sp_spaceused show negative values.
I don’t know why, but I never had problems with that.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
Run SP_SPACEUSED @UPDATEUSAGE=’TRUE’ to update the values correctly.
And also to ensure you can get information from SP_HELPDB for the database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
It worked! Thank you so much, Satya
‘ />]
]]>