Click here to Skip to main content
15,898,588 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi guys,

how can i maintain login n logoff status history,
i have use sql server 2008?

plzzzz suggest me.

thanks
Posted

If you want to keep the log in history in database, you can have a table where you could insert the user ID and log in time when the user logs in. When the user logs out, update the same record with log out time.
 
Share this answer
 
Add another field in your table. boolean type can do. that will check if your account is active or inactive. 1=active 0=inactive. change the value when you log in or log out. Goodluck
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900