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

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.



Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |