How do I obtain the MS SQL database disk usage?

Execute this command in Sql Query Analyzer

exec sp_spaceused

The database size is measured in kilobytes.

Var dette svaret til hjelp?

 Print

Les også disse

How do I get a copy of MS SQL Enterprise Manager and Query Analyser?

Microsoft does not distribute MS SQL client tools individually, they are bundled with MS SQL...

How do I configure the SQL Server Client connection protocol?

To connect to a remote MS SQL Server over the Internet using SQL clients (Enterprise Manager,...

I get "SQL Server does not exist or access is denied" error when I tried to connect to MS SQL database on your server?

This error indicates that Enterprise Manager or Query Analyzer cannot make a connection the...

How to connect to SQL Server 2000 using Query Analyser?

...

Can I have more than 1 database with my MS-SQL account?

Yes, please contact us at sales@seekdotnet.com for more information. We provide a flexible web...