How do I obtain the MS SQL database disk usage?

Problem:

How do I obtain the MS SQL database disk usage?


Solution:

To find out the database disk usage, you can execute this SQL command in Query Analyser.

exec sp_spaceused

The database size is measured in kilobytes
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

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

Problem: get "SQL Server does not exist or access is denied" error when I tried to connect to MS...

Connecting to MSSQL with out a DSN

Problem: Connecting to MSSQL with out a DSN Solution: * You can use the following string...

Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time

Problem: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time...

I'm getting a strange error message: Operation must use an updateable query(error '80004005')?

Problem: I'm getting a strange error message: Operation must use an updateable query(error...

error: Too few parameters

Problem: error: Too few parameters Solution: error type:Microsoft OLE DB Provider for ODBC...