Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / database / SQL-Server / SQL-Server-2008

SMO 101 - Getting all DB's

5.00/5 (2 votes)
17 Aug 2011CPOL 17.3K  
How to get a quick list of all DBs using SMO
To get all the DB's programatically on a local instance of SQL Server using SMO.
C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;

namespace ConsoleApplication1
{
    class Program
    {       
        static void Main(string[] args)
        {
            Server s = new Server(".\\INSTANCENAME");
            foreach (Database d in s.Databases)
            {
                Console.WriteLine(d.Name.ToString());
            }
            Console.ReadKey();
        }
    }
}

Points of Interest


Don't forget to add the references via Project >> Add Reference... >> Browse tab

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)