Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bobbykay
Starting Member
1 Post |
 Posted - 2009-05-19 : 23:41:57
|
| This maybe an old question but I can’t find the answer….Goal: Track how many times a user or each user logs on to my websiteI have an ASP front end website with a SQL 2005 back end….I have a basic login page each user has their own username and password.I need to find a way to track who, when ,where(IP ADDRESS) login to my website.Of course it should be a SQL 2005 table, I think I need a trigger but I am not sure where to start.Thank you!!!Bob |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-19 : 23:51:51
|
You have to handle this in your ASP and insert the information into the table. Trigger will not be able to give you the WHERE part.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Tracking Website logons.