Hello Scott,

SM> We have done this with the one application that we developed in-
SM> house, and it seems to have worked. I believe it runs a simple query
SM> every five minutes. Problem is that our big inventory system is off-
SM> the-shelf and we can't touch the code. Of course that's the system
SM> that they log into and stay connected all day, so it crashes every
SM> time they come back to use it. I guess the last gasp is to make the
SM> warehouse folks change the way they use the software, but then we
SM> have to deal with unhappy warehouse guys!

You may try to schedule a batch file to execute every 30 minutes, for
example. And in the batch file you can run isql with a script that
connects to the DB, perform a dummy select, and disconnect. (just a
thought to try)


--
Best regards,
Pavel Menshchikov
http://www.ls-software.com