question

Hi, I need to log the SELECT, INSERT DELETE and UPDATE statements that are executed on SQL. How can we do this? The closest I have is using the SQL trace file. It gives all the required data but the operation that the query is performing. SELECT * FROM ::fn_trace_getinfo(DEFAULT) FROM ::fn_trace_gettable('D:\TraceFileName.trc', default) But, what I specifically need is a column which contains one of the values from Select, Insert, Delete or Update depending upon the operation which the query was performing. Example an Update query might contain sub query that contains Select statement. So for this query I need Update operation in the column. Any suggestion will be appreciated.