Interview Question in Sql Server 2000


 

Interview Question :: Detect idle time

i doing one application in .net1.1 with sql server 2000 along with share point 2003. my application is that it should monitor user or employee logon and log off detail from server. for that i get that from event viewer its working fine but it also want to capture user idle time.please give me suggestion to solve it . i don't want any s/w for it it should calculate automatically.i don't want any application or s/w to calculate it.and user are connected in lan connection.my server is windows 2003 sp2
by ksk