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.

Răspunsul a fost util?

 Tipărire

V-ar mai putea interesa și

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

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

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

Do you support MSDE 2000?

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

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