'引用Microsoft SQLDMO Object Library
Private Sub Command1_Click()
Dim Server As SQLDMO.NameList '名字列表namelist
Dim appDMO As New SQLDMO.Application 'sqldmo应用
Dim i As Integer
Set Server = appDMO.ListAvailableSQLServers '得到所有的sql sever 列表
For i = 1 To Server.Count
List1.AddItem Server(i) '加入到cmbServer中,cmbServer是一个combo下拉列表
Next