I am trying to capture all select statements being performed against all the tables in a database. I tried SQL server audit, it works fine for a given table, GUI allows us to select select objects or multiple objects. Even T-SQL for doing that, we can add
multiple objects by specifying them one after the other by specifying ADD
But is there a way to specify 'audit all the tables in a database'? Even if I use the GUI to select all the tables in a database, if a new tables is created, that will not be part of audit. So I am trying to find out if there is a way to perform an audit
over all the tables in a given database
Thanks
Satya