[Last Call] Learn how to a build a cloud-first strategyRegister Now


How export a list of SQL 2005 databases to Excel?

Posted on 2009-02-11
Medium Priority
Last Modified: 2012-08-14
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?
Question by:FFNetAdmins
LVL 19

Accepted Solution

folderol earned 2000 total points
ID: 23617386
select name from sys.databases

Author Closing Comment

ID: 31545806
Works perfectly- thanks for the quick response.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question