>I need to populate a history table with all changes made to the production table (using trigger). One of the things I need to capture is who made each change, based on their windows login name. We are using Windows authentication. Though I have looked through all of the system stored procedures, and functions, I can't seem to remember the SQL syntax for capturing the login name. If someone would slap the back of my head (or just remind me of the command) it would be greatly appreciated.

Please see http://tek-tips.com/viewthread.cfm?qid=1541840&page=1