• Yes, i tried with SQL Profiler to record the event.but Unable to login into a table

    getting error " Failed to start the new trace" But I was able to trace it in a flat file without the client and server ip address.

    I am not sure Tracing using Sqlprofiler is a best solution for every day use, I am planning to run this all the day in the server and planning to pull a report out of it every week for audit review.

    please help.