I've a unique requirement, for which all my trials have failed on the backend. Please let me know if you can suggest something.

I want to track the number of times EACH user visits and store it somewhere as I have to take some specific action based on it. The project_sitelog table in the database must supposedly have that kind of informaiotn from which I can find out the info I need. I did a simple select query in a reports module and calculated the number of times a user had to use the url '%login%' or '%register%', as far as i know it worked initially, but the problem is because of some sort of caching the counter doesn;t get updated at times for 10-15 min after the user has logged out.

Then I tried using Transact-SQL triggers on aspnet_users table and tried incrementing a counter for everytime the lastactivity date for that user changed, but I cannot make it work because there is no row level trigger I can use, all rows get updated, I have a fair amount of knowledge in SQL, dont' know if I'm missing somehting obvious. Not too confident of modifying the login.ascx.vb files under the portal.

Please help. Again, my requirement is that I want to calculate the 'visits' counter for each user and store it in a table in the database.