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:
- In Object Explorer, connect to an instance of SQL Server 2005 and then expand that instance.
- Expand Databases and then click the database to view it.
- From the toolbar, click View and then click Summary.
- In the Summary pane, click Report.