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.

Var dette svaret til hjelp?

 Print

Les også disse

Can I have more logins for my MS SQL database?

No, we only provide a single database user login.

How to use SQL Management Studio Express 2005?

Open your SQL Management Studio Express 2005 on your local machine.Step 1) Type the ServerName:...

How do I access SQL Server 2008 Database using SQL Server Management Studio?

Please follow the steps listed below in order to access or connect your SQL 2008 database using...

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 MSDE 2000?

No, we do not support MSDE 2000. The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a...