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.

Hjalp dette svar dig?

 Print denne artikel

Læs også

How do I configure the SQL Server Client connection protocol?

To connect to a remote MS SQL Server over the Internet using SQL clients (Enterprise Manager,...

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

Do you support MSSQL Express?

Yes, we support the MSSQL Express Hosted Edition. If you create .mdf file on your local machine,...

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