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: Jan 22, 2009 - Revision: 1

Feedback