'列印 SQL Server
'引用 Microsoft SQLDMO Objects Libary
Dim i As Integer
Dim SQLDMOAppX As New SQLDMO.Application
Dim NameListX As SQLDMO.NameList
Set NameListX = SQLDMOAppX.ListAvailableSQLServers
For i = 0 To NameListX.Count - 1
Debug.Print NameListX.Item(i + 1)
Next
'至于列印所有数据库,肯定要先 Login
'然后再用 SQLDMO 所含数据库:
Dim SQLServerX As New SQLServer
SQLServerX.Connect "servername", "sa", "password"
Dim i As Long
For i = 0 To SQLServerX.Databases.Count - 1
Debug.Print SQLServerX.Databases.Item(i + 1).Name
Next i