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.

Hjälpte svaret dig?

 Skriv ut denna artikeln

Läs även

How to connect to SQL Server 2000 using Query Analyser?

...

I am able to view and access a SQL database other than my own while connected with Enterprise Manager, Query Analyzer, or the SQL Web admin. What is wrong?

This happens because the customer has added Guest Access/Public to their SQL...

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...

Can I have more logins for my MS SQL database?

No, we only provide a single database user login.

Do you have any Web Based Enterprise Manager?

No, we don't have that. You can just use MS SQL Management Studio from your local machine and...