SQLTeam.com | Weblogs | Forums

SQL Server Audit - Select with No Select Clause


#1

Hi
I know that SQL Server has the Audit feature for the 'Select' statement. If you enable it in a DB at a table level it captures the query. What I want is that query not to show up the actual select clause itself but the fact that a user has queried that table. Is this possible to turn off the select clause when you enable the Select Audit? Can this be achieved in any other method (extended events, etc. (no triggers please if possible)).

Thanks.