asked
SQL logging pre-existing tables
Hi, do we have any sql server system tables or any table that logs the select, insert, update actions for users. Yes, there is trace file, audit logs and we can use trace file to add data to table, but my requirement is pre- existing sql tables that automatically logs user actions like...SELECT, INSERT, UPDATE?
There's no automatic logging of who did what in a SQL Server database, so you'd have to use auditing. With insert/update/delete, you could use triggers for logging, but not for selects.
17 People are following this question.
