the sql server error log shows the same error even after creating the revised trigger.

but if i create the Audit table in the master database and then it works fine. i am able to log in and i believe all other users will be able to do the same but when i run a select statement on that Audit table i see only master listed in the DB_NAME column and not the user database.