How to get the list of sql servers

Hi,
Am on a LAN and there are several sql servers running. I wanted know the list of servers with the version. I know we can get the list of servers using cmd line prompt "OSQL -L", but i need to know the version of each server also. Is there someway to get this information for all the sql servers in the LAN
Thanks very muc
YogishYou could use SQLDMO for this.Check out
http://www32.brinkster.com/srisamp/sqlArticles/article_15.htm. You can
easily extend the procedure using more properties of SQLDMO to return the
information that you want.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:F03C14A9-47C6-4010-BD6B-1D7B4CB3A417@.microsoft.com...
> Hi,
> Am on a LAN and there are several sql servers running. I wanted know the
list of servers with the version. I know we can get the list of servers
using cmd line prompt "OSQL -L", but i need to know the version of each
server also. Is there someway to get this information for all the sql
servers in the LAN?
> Thanks very much
> Yogish