task with no window/SQL Server running

[George Copeland]

Ok, this is really starting to hack me off. My requirement is that I need
to be able to tell if the sql server service is running on the local machine
programmatically using vb6. I took a look at Karl E. Peterson's excellent
tasklist app, but it iterates through windows to identify tasks. The sql
server service has no window, so it doesn't show up. All of the other
tasklist projects that I analyzed do it the same way.

There is exactly one article on the kb about this subject, useless for my
purposes. Appleman demonstrates a legacy method, also useless.

Surely there must be a halfway decent way in vb6 to:

1. List the running tasks in the same manner that ctl+alt+del does on win me
(see image at http://www.copelandweb.com/temp/winmeclose.gif)

2. Determine if the sql server service is running on the local machine.

Any suggestions appreciated, etc.

[George Copeland]

"George Copeland" <tma...@DELETETHISmail.com> wrote in message
news:44Yr9.66$u_6.13...@newssvr12.news.prodigy.com...

> Ok, this is really starting to hack me off. My requirement is that I need
> to be able to tell if the sql server service is running on the local
machine
> programmatically using vb6. I took a look at Karl E. Peterson's excellent
> tasklist app, but it iterates through windows to identify tasks. The sql
> server service has no window, so it doesn't show up. All of the other
> tasklist projects that I analyzed do it the same way.

Nevermind boys, I cracked it. KB article Q187913 pertains:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q187913

You can find my encapsulation of the code in the article here:

http://www.copelandweb.com/vb/downloads/tasklist.zip

Have a nice day.