Check the database free space on a ms sql server

[frbo]

I would like to know wath the free space is of a database on my sql server. Is ther a possibility to check that with ks-host?

Thanks

Frederik

[KS-Soft Europe]

I would like to know wath the free space is of a database on my sql server. Is ther a possibility to check that with ks-host?

Thanks

Frederik

Frederik,

You can do this with Host Monitor ODBC Query test.
http://www.ks-soft.net/hostmon.eng/tests.htm#odbc

According to MySQL 5.1 Reference Manual the query should look like
select sum(data_free) from INFORMATION_SCHEMA.PARTITIONS - for all the data files or
select sum(data_free) from INFORMATION_SCHEMA.PARTITIONS where table_schema = 'schemaname' for certain schema only.

Regards,
Tom

[frbo]

thanks