By audit trail you mean sql profiler trace? You can track all these activities in the sql trace. Use the blank template and put the filters on loginname and the the operations you want to track.