-
Capturing user activity in the database using SQL Server Auditing functionality
SQL Server comes with a build in audit functionality that saves a lot of development effort when one of the business requirements states is to keep a record of user activity in the database. For each query executed in the database, SQL Server Audit captures the names of the affected tables, SQL statement used for…