Is there any third party s/w that lists SQL servers in a network and query more info about the server?

[SQLDBA]

Is there any third party s/w that lists SQL servers in a network and
query more info about the server?

[louis]

Per this msft support article, just run this in query analyzer (mssql
2000).

http://support.microsoft.com/kb/321185/EN-US/

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY
('productlevel'), SERVERPROPERTY ('edition')

[SQLDBA]

Thanks Louis... This really helped. But how do I query this info of all
the SQL servers in a network? This only gives me info about the one
that I execute the script from... Is there a way to do that?
Thanks again..!

[Ross Presser]

On 16 Dec 2004 05:55:49 -0800, SQLDBA wrote:

Thanks Louis... This really helped. But how do I query this info of all
the SQL servers in a network? This only gives me info about the one
that I execute the script from... Is there a way to do that?
Thanks again..!

osql.exe -L is supposed to enumerate the servers on the network.

[SQLDBA]

I did some research on the groups and found out about SpotLight on SQL
servers by Quest. Has anyone tried this and can any one please let me
know if its worth buying this? Any other competiters who has a better
tool than this?

Thanks again...

[JinJJa]

>Thanks Louis... This really helped. But how do I query this info of all

the SQL servers in a network? This only gives me info about the one
that I execute the script from... Is there a way to do that?
Thanks again..!

Yes, you can utilize OSQL to run queries on all the SQL servers in the network.
You may have to insert all the outputs into a table and filter them.

just type "help osql" at the command prompt.

Joe
MCDBA, MCSD, OCP