1.如何采用使用SQLDMO组件?
菜单-项目-添加引用-COM-Microsoft.SQLDMO.Object
2.
//获得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;
}