Hi Dennis -
I have seen a number of instances where this
method doesn't work. It was supposed to work, but
it didn't.
Bernie
At 12:41 PM 1/16/2007, you wrote:
I discovered by accident today that the first connection to a db
clears the ghost connections (invalid user count)
This works with every version at least from 6.5++ on.
One does not have to force single user mode.
Just making sure that all connections to the db are closed at the
same time
once a day should prevent the buildup of ghost connections over time.
Dennis McGrath