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.

Ha estat útil la resposta?

 Imprimeix aquest Article

Llegir també

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

Can I use mssql 2008 if I built my database using mssql 2005?

Yes you can use the mssql 2008 although you build your db using mssql 2005. The database can be...

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

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