How to audit all DML operations on a SQL Server 2008 R2 database

2 votes

1 answer

889 views

sql-server sql-server-2008-r2 audit dml

                          In order to assess options of implementing indexed views, I want to check the usage of DML operations of the tables. 
The database is new to me as well as the relevant business knowledge, so I just have no idea. 

Is there a way to quickly collect a statistic within couple of days? 

I am using Standard Edition.

Asked by Magier (4827 rep)

Aug 19, 2015, 04:10 PM
Last activity: Oct 6, 2023, 11:42 AM

How to audit all DML operations on a SQL Server 2008 R2 database

Related Questions