exec sp_spaceused | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

exec sp_spaceused

i executed the exec sp_spaceused in one of my databases, the output came as database_name size unallocated_space
TestDB 35644.81 MB0.00 MB Do i need to take any action for this, or how can i handle this ?? thanks
Some times sp_spaceused procedure will not give you the correct information because it is based on statistics…
Use…
EXECC sp_spaceused @updateusage = N’TRUE’ to get the correct info… I think your db has 0 mb allocated free space, you can configure your db to auto grow or you can increase your db size manually through SSMS or Query window…
MohammedU.
Moderator
SQL-Server-Performance.com
]]>