How do I get the taskpad view in SQL Server Management Studio as it was in SQL Server 2000 version?

Printer friendly

Question:

How do I get the taskpad view in SQL Server Management Studio as it was in SQL Server 2000 version in order to see database data & log files usage?

Answer:

SQL Server 2000 Enterprise Manager has a feature to display database data & transaction log file usage in a taskpad view when a database's properties are selected. This feature has been enhanced in SQL Server 2005 when using Management Studio. This facilitates a simple overview of the total size and used space for database files like that available in Enterprise Manager for SQL 2000 via the Taskpad view. Follow these steps:

1. In Object Explorer, connect to an instance of SQL Server 2005 and then expand that instance.
2. Expand Databases and then click the database to view it.
3. From the toolbar, click View and then click Summary.
4. In the Summary pane, click Report.

Your Name
Email	(Emails will not be displayed on the site or used for promotional purposes)
Comment
Type characters in the image	(case sensitive)