changing the insert statement in the trigger worked but why in the SYSTEM_USER column and the DB_NAME column I see only sa and master respectively.

i clicked options and changed the database to the users database and then logged in but when i select the Audit table still it shows up as "master" in the DB_NAME column and "sa" in the SYSTEM_USER column

can you please help..