I have an Update Audit Trigger. When the user makes an update from the front-end it works well. Is there a way to ensure that if a user logs on to the SQL Server through Enterprise Manager or SQL Query Analyzer and makes any change to the data, it should register his/her username. The user could also log on Query Analyzer using Windows Authentication, in which case it should pick the name of the user and the box that is used to access the DB.