MS SQL Server - Checking to see if SQL Server on machine is up and running

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Checking to see if SQL Server on machine is up and running

simon whale

2006-10-24, 6:33 pm

Hi All,

i have a doos script that downloads from an ftp site and extracts data from
zip files before running a DTS Package.

my question is; is there a way to check to see if SQL is running and if not
start it?

any help woudl be appreciated

Simon Whale

Hari Prasad

2006-10-24, 6:33 pm

Hi,

Take a look into this script. I have not tested this.

http://www.softtreetech.com/24x7/archive/35.htm

Thanks
Hari
SQL Server MVP

"simon whale" <hell@nospam.com> wrote in message
news:%23M8$s1J5GHA.1012@TK2MSFTNGP05.phx.gbl...
> Hi All,
>
> i have a doos script that downloads from an ftp site and extracts data
> from zip files before running a DTS Package.
>
> my question is; is there a way to check to see if SQL is running and if
> not start it?
>
> any help woudl be appreciated
>
>
> Simon Whale
>

Sponsored Links