By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,414 Members | 1,586 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,414 IT Pros & Developers. It's quick & easy.

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

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

Jul 23 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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')

Jul 23 '05 #2

P: n/a
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..!

Jul 23 '05 #3

P: n/a
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.
Jul 23 '05 #4

P: n/a
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...

Jul 23 '05 #5

P: n/a
>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
Jul 23 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.