Finding SQL Servers and Patch levels on a network

From: Ben (benjy_at_allfreetech[DOT)
Date: 11/06/03 

Date: Thu, 6 Nov 2003 20:23:00 -0000

Hi,
I'm planning to use SQL DMO to get me a list of all available SQL Servers on
a network using code like the snippet (and the source article) given below.
Does anyone know if there is a way of finding more information about the
servers in question such as the actual version and the patch which was
applied etc? managing sql server patching is becoming a nightmare nowadays

any thoughts?

cheers
ben
Dim sqlApp As New SQLDMO.Application
Dim NL As SQLDMO.NameList

Set NL = sqlApp.ListAvailableSQLServers
For index = 1 To NL.Count
    cboServers.AddItem NL.Item(index)
Next
http://msdn.microsoft.com/msdnmag/issues/01/05/sqldmo/default.aspx