I would like to create a audit log of update and delete queries against a table. I want the log on the server side, since access will be done using various clients via ODBC. I would like to capture the user, current datetime and the query statement. My thought was to accomplish this by creating a rule that will insert the information into a log table.
How can I captures the query statement so that I can place it in a insert query? Is there a variable in the server that holds the query statement as a string? Am I about to go in over my head (again)? Thanks, Andrew ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
