From: Eliezer Croitoru <eliezer@...>
Date: 2012-07-14T00:42:24+09:00
Subject: Re: detect ms sqlserver status

On 7/13/2012 9:32 AM, Edward QU wrote:
> Hi There
> I just want to use ruby script to detect if the MS SQLserver works
> well/status, beside use "connected", is there any other better method?
> thanks.
<SNIP>
you can try to run some specific query that results a specific result to 
make sure the server is serving data.
what data do you need on the server?

Eliezer

-- 
Eliezer Croitoru
https://www1.ngtech.co.il
IT consulting for Nonprofit organizations
eliezer <at> ngtech.co.il