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();
}
}
}
Showing posts with label smo. Show all posts
Showing posts with label smo. Show all posts
Tuesday, August 23, 2011
Get all the DB's programatically
To get all the DB's programatically on a local instance of SQL Server using SMO.
Subscribe to:
Posts (Atom)