I am using the SQLServerSelect Dialog and I have a question. What servers does it show? When I run it on one of our test machines it seems to display every SQL Server that machine has ever connected to.
So my question is really this; if the install is run on a new PC that has never connected to any SQL Server, will it still display the available servers that are on the network, or will the list be blank because the PC has never connected to any server?
From what I recall the SQL Login dialogs in both InstallScript and MSI projects rely on windows API's to query for servers. I forget which API it uses exactly, but one checks the domain controller for registered servers, and the other sends out a broadcast ping, and waits until the SQL Browser server on listening PC's responds.
Recent SQL Servers, last I was aware, don't have any effect. Although, this may change if you're talking about Oracle or MySQL, since these use different methods of browsing that I can't say I know much about.
