script to check connectivity | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

script to check connectivity

Hi<br /><br />I have 20 sql servers running in different servers in same network.Is there any script available to check connectivity to all servers from one and output to any text file or somthing like that??<br /><br />rajiv<br />Lazy DBA <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br /><br /><br /><br />
Link <a href=’http://www.databasejournal.com/scripts/article.php/3494931′ target=’_blank’ title=’http://www.databasejournal.com/scripts/article.php/3494931′<a target="_blank" href=http://www.databasejournal.com/scripts/article.php/3494931>http://www.databasejournal.com/scripts/article.php/3494931</a></a> gives you an vb script from which you can test the connectivity of a one server<br /><br />testconnectivity.vbs Servername dbname Loginname Password<br /><br />dbname- you can put master every time.<br />You have to store other data in some where may be in registry (THen their will be some secuirty issues) and loop all the sql servers and write to text file with the output<br /><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by gkrishn</i><br /><br />Hi<br /><br />I have 20 sql servers running in different servers in same network.Is there any script available to check connectivity to all servers from one and output to any text file or somthing like that??<br /><br />rajiv<br />Lazy DBA <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br /><br /><br /><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
Hi Thanks for the script.When and where to execute this? is it through browser?Let me know Thanks rajiv
Well, it all depends on your requirment, YOu can run this on any pc
YOu cna write simple vb app sp that it calls this function and you can schedule to execute this app when you want to execute
quote:Originally posted by gkrishn Hi
When and where to execute this? is it through browser?Let me know
rajiv

]]>