<div>
Works perfectly- thanks for the quick response.
</div>


Works perfectly- thanks for the quick response.

<div>
<div class="content wysiwyg-content">
I'm trying to export a list of my databases that are displayed in the SQL Server Management Studio. When I expand the SQL server, then expand and double-click on the Databases folder, I can see all my databases on the right side &quot;summary&quot; window. The problem is that I can't select databases and and choose an &quot;Export List&quot; like the old SQL 2000 Enterprise Manager had. What's the new way to do this?
</div>
</div>


I'm trying to export a list of my databases that are displayed in the SQL Server Management Studio. When I expand the SQL server, then expand and double-click on the Databases folder, I can see all my databases on the right side "summary" window. The problem is that I can't select databases and and choose an "Export List" like the old SQL 2000 Enterprise Manager had. What's the new way to do this?

How export a list of SQL 2005 databases to Excel?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.