From: Eliezer Croitoru Date: 2012-07-15T03:48:31+09:00 Subject: Re: detect ms sqlserver status On 7/14/2012 8:33 PM, Edward QU wrote: > Eliezer > Thanks for your reply, actually, I just want to know if this sql server > is live well or locked. > > Edward > what locked means? Locked on a firewall level? if so you can use the tcp-ping or just plain TCPclient socket and verify it almost the same way you have done. it will just make it in a lower level that requires only socket and not dbi. Eliezer -- Eliezer Croitoru https://www1.ngtech.co.il IT consulting for Nonprofit organizations eliezer ngtech.co.il