Capture which user log into the ASP?

[fredong]

Currently, I have a web page that was created by ASP and it is using the COM, and ODBC DSN 'sa' login link to the MSSQL 2000 Database. Thus, I do not know who login to the web page because their are using the same pipeline from the sa login in the sp_who or current activity. Is there a way to find out or capture form the ASP frontend which user login and how long did they log in. Any input is appreciated. Thanks

 

[krisbrixon]

you could always create a login scheme to track users and hold there information somewhere.

I'm thinking like part on asp.net forums on the left where it shows who is online

http://www.asp.net/Forums/default.aspx?tabindex=1&tabid=39

I would caution on having different logins for the server. the server can not connection pool if the connection strings are different (and different logins to the db means different connection strings). I think.

Kris

 

[fredong]

Is there a tools or scripts that I can capture the user logins and time of logging in.Thanks.