Hi Josh,
>I usually create a table of users then lock each users record while that user's using the system. This way, if a user's machine crashes the record lock will be released by the network OS.
Tell me if I've understood what you mean :
1) Set Multilocks should be ON
2) When the user logs in with UserId and Password I try to lock his/her record.
3) If the lock is successful then the user isn't already logged. If not, the user is already looged or someone else is trying to us the same account.
4) When the user closes the app the lock is removed.
Right ? If so, it sounds very easy and good. But suppose that the App crashes for whatever reason :( The lock wouldn't be released, and the user should be forced to reset the machine...
>
>In SQL Server I use the the procs system table to see what processes are running on the server.
How could it be done programmatically ?
Sincerely,
Andrea Brajuka