thank you for all the help. i am getting the data in the table now but as you said it still shows the db name as "master" and not the user database. I have one more question, do i have to give "Insert" right on the Audit table to all the users? because if i don't i get the same error message and only sys admin is able to log in but when i give Insert right on that table to all users then everyone is able to log in.