sql server smo to list database names

sql server smo code to list the databases

1. create a new console application in Visual Studio 2005
2. Add the below references



• Microsoft.SqlServer.Smo.dll
• Microsoft.SqlServer.SmoEnum.dll



3. add the below code in the code window

Imports Microsoft.SqlServer.Management.Smo Module Module1 Sub Main() ' create a server instance Dim mysvr As New Server("SQLHASP1\SQLDEV01") 'create a database instance Dim mydb As New Database mydb.Name = "adventureworks" 'connect to the server using windows authentication mysvr.ConnectionContext.LoginSecure = True ' getting the list of database names For Each database As Database In mysvr.Databases Console.WriteLine(database.Name) If mydb.Name.ToUpper = database.Name.ToUpper Then Console.WriteLine("---------") ' write teh code below specific to a database End If Next Console.Read() 'to allow the user to read the contents on the console End Sub End Module