Beverley (8/31/2009)

---

I'm not sure I fully understand the question, but we do something similar (I think) to what you're asking.

The application knows the logon user (e.g. dmn\jdoe)

But then it connects to the database using a SQL account (e.g. MyDataWriter)

Then in the table(s), there is a field for UpdateUser, which the stored procedure fills with the actual user ID (dmn\jdoe)