I created this Hit Counter to keep track of the use of our Company Intranet. On the SQL Server (in our case MSSQL 7), you will need to have a table named Hit_list_tbl with the columns row_id (identifier, auto incrementing), page_hit (name of the page returned), time_hit (datetime) and user_id (holds domain and user name).
At the end of the page clear and close everything (not included).
<% ' The Hit Counter part set OBJdbConn = Server.CreateObject(