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

Is there any third party s/w that lists SQL servers in a network and
query more info about the server?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')|||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..!|||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.|||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...|||>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

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

Is there any third party s/w that lists SQL servers in a network and
query more info about the server? I need to find out the sql version,
whether its a msde or a msee. Also the service pack details and list
the databases in that server. Any help appreciated...

Thanks..!No need to buy a 3rd party apps for this.

use "osql -l" (try capital L if this doesn't work) at the command prompt.

If you want to obtain SQL info just use the following sp and xp. You can also
obtain these information remotely (without EM or QA) using osql.

exec master..xp_msver
exec sp_server_info