executed

EXEC sp_spaceused @updateusage = N'TRUE';

and now the result looks much better

database_size unallocated space

------------------ ------------------

8605.13 MB 199.59...

thanks for your quick reply.

here is the output of the sp_spaceused proc.

database_size unallocated space

------------------ ------------------

8605.13 MB ...

Hi,

thanks for sharing this procedure. I tried this on one of our servers and wondering about the reserved_mb metric in the fourth recordset about databases.

In this resultset there are several...