Good afternoon!
I am wondering if there is a way to log queries that have occured on a database or specific table? For example, is it possible to log the user, the query type (insert, update, delete, select, execute etc...), date, time, table, row and column(s) affected by the queries (if applicable) so that someone can in effect, "audit" our system?
This isn't a web database, it's a local sql server on our intranet.
Any suggestions or ideas would be greatly appreciated!