Timestamping a record with the current user name

[strtech]

I'm using Forms Authentication and a SQl 2005 database. I want to track who entered new records into the table. Of course I'm able to get the time and date but the asp.net current user is not being added to the table.

I have one account accessing the sql database so if I use the suser_name or one of the others properties, I get that user account instead of the current user that is entering the record. I've also tried the user_name() and Session_User property.

What default property should I use?

 

[strtech]

Ignore this post. I've figured it out.

 

[ca8msm]

And for the benefit of other users, how did you figure it out and what was the solution?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.