怎样获得Sqlserver 2000得实例列表和运行在一个实例上得数据库列表-CSDN博客

本文链接：https://blog.csdn.net/greennetboy/article/details/551101

1.如何采用使用SQLDMO组件？

菜单－项目－添加引用－COM-Microsoft.SQLDMO.Object

//获得SqlServer 2000上得Server Instance列表
  public static System.Collections.Specialized.StringCollection GetSqlInstances()
  {
   System.Collections.Specialized.StringCollection instaces= new System.Collections.Specialized.StringCollection();
   SQLDMO.Application sqlApplication= new SQLDMO.ApplicationClass();
   SQLDMO.NameList sqlServerIntances=sqlApplication.ListAvailableSQLServers();
   for(int i=0;i<sqlServerIntances.Count;i++)
   {
    object svr=sqlServerIntances.Item(i+1);
    if(svr!=null)
    {
     instaces.Add(svr.ToString());
    }
   }
   return instaces;
  }

3.
  //获得Sqlserver 2000一个Server Instance上得数据库列表
  public static System.Collections.Specialized.StringCollection GetAllDatabases(string server,string uid,string pwd)
  {
            System.Collections.Specialized.StringCollection databases= new System.Collections.Specialized.StringCollection();
   SQLDMO.SQLServer sqlServer =new SQLDMO.SQLServerClass();
   sqlServer.Connect(server,uid,pwd);
   foreach(SQLDMO.Database db in sqlServer.Databases)
   {
    if(db.Name!=null)
    {
                    databases.Add(db.Name);
    }
   }
   return databases;
  }