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.

Esta resposta lhe foi útil?

 Imprimir este Artigo

Veja também

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

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

Can I have more logins for my MS SQL database?

No, we only provide a single database user login.

How to connect to SQL Server 2000 using Query Analyser?

...

Do you have any Web Based Enterprise Manager?

No, we don't have that. You can just use MS SQL Management Studio from your local machine and...