'列举有效的SQL Server
Private Sub Command1_Click()
On Error Resume Next
Dim i As Integer
Dim oNames As SQLDMO.NameList
Dim oSQLApp As SQLDMO.Application
Set oSQLApp = New SQLDMO.Application
Set oNames = oSQLApp.ListAvailableSQLServers()
For i = 1 To oNames.Count
Debug.Print oNames.Item(i)
Next i
End Sub