Folks, I knew that third-part tool SQLRecon written with VB can perform this. But I really want to have my own scripts suitable for my environment. The Situation is: ---------------------------------------- There exist thousands of the windows hosts on the domain, We have a list of the IP address for these windows servers. We only know some of them host SQL instance. The purpose of the script should be 1. For the known windows hosts with SQL instance, need to know whether the sql services is up? 2. For other unknow windows hosts, need to check whether they host sql server instances, if host, what is the status of the sql instance? ------------------------------------------ Appreciate you input. ------------------ Bug explorer/finder/seeker/locator ------------------
Hi, i would suggest to Refer for SQLPing http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx Hemantgiri S. Goswami "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami ------------------------ http://hemantgirisgoswami.blogspot.com
Thanks, ghemant. SQLPing, SQLPing2, SQLRecon all can do this work. I want to get some ideas to develop own sql script for my environment ------------------ Bug explorer/finder/seeker/locator ------------------
YOu can find such programs or scripts (open source) to perform the tasks you're looking, and as far as third party tools are concerned it is better to contact Vendor. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
Satya, can you please recommend me several good open source SQL Server script sites? appreciate it ------------------ Bug explorer/finder/seeker/locator ------------------
[<img src='/community/emoticons/emotion-1.gif' alt='' />] I wish I could... but Google is your best friend in this case.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
Since when I google it, lots of junk information will pop up. I need to filter them to find the best one. The same thing, it takes me some time to find here and finally get used to. ------------------ Bug explorer/finder/seeker/locator ------------------
