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.

Byla tato odpověď nápomocná?

 Tisknout tento článek

Také čtěte

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

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 logins for my MS SQL database?

No, we only provide a single database user login.

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 do I find my MS SQL Server or Host Address?

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