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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • SQLDBA
    #1

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

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

    Tags: None
    • louis
      #2
      Re: 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')

        Comment

        • SQLDBA
          #3
          Re: Is there any third party s/w that lists SQL servers in a network and query more info about the server?

          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..!

            Comment

            • Ross Presser
              #4
              Re: Is there any third party s/w that lists SQL servers in a network and query more info about the server?

              On 16 Dec 2004 05:55:49 -0800, SQLDBA wrote:
              [color=blue]
              > 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..![/color]

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

                Comment

                • SQLDBA
                  #5
                  Re: Is there any third party s/w that lists SQL servers in a network and query more info about the server?

                  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...

                    Comment

                    • JinJJa
                      #6
                      Re: Is there any third party s/w that lists SQL servers in a network and query more info about the server?

                      >Thanks Louis... This really helped. But how do I query this info of all[color=blue]
                      >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..![/color]

                      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

                        Comment

                        Previous template Next
                        Working...