How to check the size of a SQL database

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
REFERENCES
Properties

Article ID: 963310 - Last Review: 01/22/2009 23:04:25 - Revision: 1.0

Microsoft Business Solutions for Analytics–Forecaster 6.7, Microsoft Business Solutions for Analytics–Forecaster 6.5

  • KB963310
Feedback