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.

Je li Vam ovaj odgovor pomogao?

 Ispiši članak

Također pročitajte

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

How do I find my MS SQL Server or Host Address?

Please follow these steps below to obtain that information : Login to your DotNetPanel :...

How to connect to SQL Server 2000 using Enterprise Manager?

To connect to your Microsoft SQL Server database using Enterprise Manager to manage your...

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

How to transfer SQL database from My Database Server to your Database Server

From the Start Menu, select Programs -> Microsoft SQL Server -> Import and...