Re: Finding and Identifing SQL Servers

Stacey
In order to get this info you have to login SQL Server
http://dimantdatabasesolutions.blogspot.com/2007/04/whats-version-of-sql-server.html



"Stacey" <Stacey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9150288E-C6B4-48EE-A33D-5F2F79BF2F04@xxxxxxxxxxxxxxxx
I was woundering if anyone has done any scripting to locate and Identiify
SQL
Servers on there network? I know that I can use sqlcmd /L but I want to
beable to identify which version they are running. The monitoring tools
are
not installed on all machines and I want to ensure that we are linced for
each installed on the network.

Would be nice to know if they are up to-date on their patches also.

Any help would be great. And at this time we will not be buying any tools
in near future.

Thanks for any help.


.

Relevant Pages

  • RE: SoapExtension and NetworkStream
    ... seem like good monitoring tools. ... percentage of completion of the data being sent across the network. ... the stream I am able to intercept with the SoapExtension is ... too late in the deserialization process because it is already a memory stream ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: SNMP Service?
    ... If you don't know what SNMP is then you probably don't need it. ... monitoring and managing 'devices' on a network. ... Management & Monitoring Tools you will see the options for SNMP, ...
    (microsoft.public.windowsxp.network_web)
  • Re: Network monitor software
    ... yes network monitoring tool comes with windows 2003 but you have to install ... it from add/remove programs then windows components and then select network ... monitoring tools from managing and monitoring tools. ... version which comes alongwith Systems Management Server 2003 which allows ...
    (microsoft.public.windows.server.general)
  • Re: Wi Fi Lan
    ... >I've set up a small local wi fi network inside the builing I live in. ... Yes but it won't work with just any router. ... MAC address, you can capture all his traffic. ... There are huge number of other monitoring tools around. ...
    (alt.internet.wireless)
  • Re: Network Monitor in SBS2003?
    ... Install it the same way you would on a Windows 2000 serve: ... > - Select Management and Monitoring Tools and click Details ... > - Turn on the checkbox next to Network Monitor Tools ...
    (microsoft.public.windows.server.sbs)