dbTalk Databases Forums  

Inventory SQL Server machines on your network

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Inventory SQL Server machines on your network in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mjlefevre
 
Posts: n/a

Default Inventory SQL Server machines on your network - 02-21-2008 , 08:51 AM






What is a good simple way to scan the servers in your network for SQL
Servers?

Does anyone have any scripts or code that would show me how to do
this?
I think WMI might be able to do this but don't know where to start.

If possible I'd like to be able to get the version (2000 or 2005) if
possible.

Thanks,
Kelly Greer
kellygreer1 (AT) nospam (DOT) com
change nospam to yahoo

Reply With Quote
  #2  
Old   
Tom van Stiphout
 
Posts: n/a

Default Re: Inventory SQL Server machines on your network - 02-21-2008 , 08:51 PM






On Thu, 21 Feb 2008 06:51:18 -0800 (PST), mjlefevre
<mjlefevre (AT) gmail (DOT) com> wrote:

Here is one way:
http://msdn2.microsoft.com/en-us/library/a6t1z9x2.aspx

-Tom.



Quote:
What is a good simple way to scan the servers in your network for SQL
Servers?

Does anyone have any scripts or code that would show me how to do
this?
I think WMI might be able to do this but don't know where to start.

If possible I'd like to be able to get the version (2000 or 2005) if
possible.

Thanks,
Kelly Greer
kellygreer1 (AT) nospam (DOT) com
change nospam to yahoo

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.