Total spaceused and total allocated

[kydongau]

Anyone has a "one sql statement" to get the total spaceused and total
space allocated of an instance ? ie same as sum of relevance fields
from sp_spaceused for each database in an instance, that works accross
version of mssql from 6 onward.
Thanks
KD

[Erland Sommarskog]

kydongau (ky******@yahoo.com.au) writes:

Anyone has a "one sql statement" to get the total spaceused and total
space allocated of an instance ? ie same as sum of relevance fields
from sp_spaceused for each database in an instance, that works accross
version of mssql from 6 onward.

Since the architecture for 6.0/6.5 is radically different from later
versions of SQL Server, there is no statement that works on all versions
of SQL Server.

It would possible to give some rough numbers for 6.0/6.5 with a single
statement, but not for later versions, because the information is spread
out in the various databases.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp