NuRoN Consulting, INC

So I needed to create an audit trail on SQL with ASP_NET authentication. I did some digging and came up with:

http://www.simple-talk.com/sql/database-administration/pop-rivetts-sql-server-faq-no.5-pop-on-the-audit-trail/
http://www.auditdatabase.com/Downloads.html

I took the code from AuditDatabase.com and made some changes.

You can find it all in the downloads area: http://www.nuronconsulting.com/File-Download.aspx in the SQL folder Auditing.
There is also a script there that will generate the triggers for this.