Can we audit the activity inside the SQL Server 2008 to capture SELECTs activity? For the first time I though CDC will be useful to DBAs in auditing the activity on the database, but its not entirely. It is equivalent to auditing functionalities and in Read More...