Hi all !
I have a table that is updates ever 5 - 10 mins by my application to show connected users. I plan on creating a service to drop old connections to monitor the application. The table structure is as follows
UID uniquieidentifier
UserID int
LastContact datetime
Workstation varchar(100)
How would I go about deleting the record if it older than a given parameter (say 10 minutes) assessing the time against the lastcontact field?
Regards
Steve
Start Free Trial
