Chuck,
That's a great explanation! However, I'm still wondering about the value =
of a pause/continue vs. a start/stop design. Why would you ever want to =
pause a service with the existing set of users? If you're going to =
"pause", why not stop completely and do what ever you need to do cleanly =
without affecting any connected users?
With all the work you do with SQL Server, do you find that there are =
times that it makes sense to pause/continue SQL Server vs. Stop/Start =
it?
Are you or your companions at EPS building VFP based NT Services for =
your customers?
Thanks!
Malcolm
PS: Do you know anything about the artist who designed the VFP CODE =
magazine cover? Great "Fox" graphic - would make a cool =
T-Shirt/Sweatshirt. Do you think EPS would be willing to disclose the =
artist's name?
-----Original Message-----
From: profox-bounces /at/ leafe DOT com [mailto:profox-bounces@leafe.com]On
Behalf Of Chuck Urwiler
Sent: Friday, May 30, 2003 9:26 AM
To: ProFox Email List
Subject: RE: Questions on NT services and a request for VFP based
NTServicetips, tricks, and traps
Malcolm,=20
Since every service works differently, it's hard to answer #1 with any
certainty. I know for a fact how the SQL Server service works: if you
pause it, the service is still running, but new logins are not allowed.
If you stop the service, that kicks everyone out of the server.=20
It really depends upon how people have implemented their service.=20
I see Mike Stewart gotcha covered on #2 and #3.=20
-Chuck Urwiler, MCSD, MCDBA
http://www.eps-software.com
-----Original Message-----
From: Malcolm Greene [mailto:mgreene /at/ bdurham DOT com]=20
Sent: Thursday, May 29, 2003 4:43 PM
To: ProFox Email List
Subject: Questions on NT services and a request for VFP based NT
Servicetips, tricks, and traps
1. What is the value of pausing and continuing a service vs. stopping
and restarting a service?
2. Is there a way for the Windows SCM (Service Control Manager) to
automatically restart failed or terminated services if we have a NT
service designated with a specific property? Or do we need to use a 3rd
party product for that type of functionality?
3. Does anyone have any experience running VFP applications as NT
Services? I know this is possible and have researched the topic on the
UT. What I'm curious to know is what were the real life problems you
encountered and whether or not you decided to use the NT Resource Kit's
SRVANY.EXE to host your service or whether you decided to use a 3rd
party alternative to SRVANY. Tips, tricks and traps?
4. Using .NET is not an alternative for this project.
Thanks!
Malcolm
[excessive quoting removed by server]
©2003 Malcolm Greene |
