I have written an app using Delphi 6 and SQL Server Database, to be used under Windows 2000 environment.
There are times when the application will need to be closed to perform end of month processes. I have written code which will lock users out upon entering the application, if the application is "CLOSED FOR MAINTENANCE"
My question is How do I get a list of users who are still using the application if they are already in the APPLICATION, so that I can tell them to exit ?
I would like to do this via Delphi Code, and I will not have access to SQL SERVER Administration once the application is deployed.