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.

這篇文章有幫助嗎?

 列印本文

Also Read

I get "The server principal "username" is not able to access the database "databasename" under the current security context. (Microsoft SQL Server, Error: 916) " after I tried to login via MS SQL Management Studio?

To fix this SQL Server Management Studio 2008 bug please do the following: Open SQL Server...

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

How can i generate scripts for MS SQL Database?

Your default database user don't have privillages to do that You can just create a support...

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 restore my mssql database?

Old control panel -    Upload the backup file in .zip extension onto your root...