How to check the size of a SQL database

Article translations Article translations
Article ID: 963310 - View products that this article applies to.
Expand all | Collapse all

SUMMARY

How do I get the size and collation setting of databases attached to SQL Server.

MORE INFORMATION

Microsoft SQL Server 2000:
  1. Open SQL Query Analyzer
  2. Choose the Master Database
  3. Execute sp_helpdb
Microsoft SQL Server 2005:
  1. Launch Microsoft SQL Server Management Studio
  2. Click on New Query Button
  3. Execute sp_helpdb

Properties

Article ID: 963310 - Last Review: January 22, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Business Solutions for Analytics–Forecaster 6.7
  • Microsoft Business Solutions for Analytics–Forecaster 6.5
Keywords: 
KB963310

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com