积极答复者
要如何查詢区网内有多少SQL SERVER存在呢

问题
答案
-
- 已标记为答案 CaillenModerator 2016年2月16日 1:53
-
你好,GodG
The link provided by Simon Cai above is very exciting and you’d better have a try. Besides, you could have a look at the following article which provides another idea to get the SQL Server list by sending out a Broadcast UDP packet on port 1434, with the contents of just a byte of 0x02, to which each server would respond. Or, you could try to use the SmoApplication.EnumAvailableSqlServers to achieve your need.
http://www.codeproject.com/Articles/12336/Locate-SQL-Server-instances-on-the-local-network
Best Regards,
Albert Zhang
- 已标记为答案 CaillenModerator 2016年2月16日 1:53
全部回复
-
- 已标记为答案 CaillenModerator 2016年2月16日 1:53
-
你好,GodG
The link provided by Simon Cai above is very exciting and you’d better have a try. Besides, you could have a look at the following article which provides another idea to get the SQL Server list by sending out a Broadcast UDP packet on port 1434, with the contents of just a byte of 0x02, to which each server would respond. Or, you could try to use the SmoApplication.EnumAvailableSqlServers to achieve your need.
http://www.codeproject.com/Articles/12336/Locate-SQL-Server-instances-on-the-local-network
Best Regards,
Albert Zhang
- 已标记为答案 CaillenModerator 2016年2月16日 1:53