'引用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下拉列表 NextEnd Sub
'引用Microsoft SQLDMO Object Library Private Sub Command1_Click() Dim Server As SQLDMO.NameList Dim appDMO As New SQLDMO.Application Dim i As Integer
Set Server = appDMO.ListAvailableSQLServers
For i = 1 To Server.Count List1.AddItem Server(i) NextEnd Sub
非常感谢lxcc(虫子|专注于抢分)虫子大侠!按照你上面的做法已经成功获得局域网内部的所有SQL Server 2000 的服务器名称,得到本机的名称为 (local),我奢侈地再想问一下,能不能得到本机的实际名称,不要为 (local)?(你说的方法已经解决了我的问题!万分感谢!)
EXEC MASTER..XP_CMDSHELL 'OSQL -L'这一句SQL语句 就可以得到当前网络上所有的SQL SERVER 服务器的名称
select SERVERPROPERTY('ServerName') 试试这个吧,得到当前SQL SERVER 服务器名称
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下拉列表
NextEnd Sub
Private Sub Command1_Click()
Dim Server As SQLDMO.NameList
Dim appDMO As New SQLDMO.Application
Dim i As Integer
Set Server = appDMO.ListAvailableSQLServers
For i = 1 To Server.Count
List1.AddItem Server(i)
NextEnd Sub
额外地问一句,能否得到本机的实际实例名,不要为“(local)”?