How to Connect to an Instance Name Using SMO

1. Create your Visual Studio Project

2. Add the following references in your project

3. Include the following using statement:

using Microsoft.SqlServer.Management.Smo;

4. Add your server object. Normally, you would use the following format in your Server object:

String serverName  = "JUBILEE";

Server srv         = new Server(serverName);

Database db        = srv.Databases["AdventureWorks"];

txtServerInfo.Text = srv.Information.VersionString +

                     System.Environment.NewLine;

However, if you have an instance name, you have to specify the SERVERINSTANCE name in your Server object. In C# code:

Server srv         = new Server(serverName);

Database db        = srv.Databases["AdventureWorks"];

txtServerInfo.Text = srv.Information.VersionString +

                     System.Environment.NewLine;

Rating: 0.0/10 (0 votes cast)

Rating: 0 (from 0 votes)

Be Sociable, Share!

Filed under: SMO

belle’s sql musings