Question for Pop Rivett:

In the article by Pop, Pop Rivett's SQL Server FAQ No.5: Pop on the Audit Trail[1], you use 'system_user' to identify the user that made the change.

What are my options if I'm using a generic login to take advantage of Connection Pooling? How would I identify the actual user that makes the change?

Thanks!

[1] http://www.simple-talk.com/sql/database-administration/pop-rivetts-sql-server-faq-no.5-pop-on-the-audit-trail/