: 1. The text of the SQL Queries report only shows Drop table : Create table, Alter table sql statements. It does not : show any update, delete, insert statements. It only means that you are not auditing them. Please enable auditing for these operations in the System Audit/Set Audit Options. If you are not sure which options to enable, enable them all. If you have any filters, please remove. : 2. The Tools/User Activity tool only shows the : users connection information, it does not show any : sql query statements. Go to the second level, expand the connection to see actual activities. again if you don't get them it means you are not auditing them. You only can see what's being audited. : 3. The select * from db_audit.sys_audit_trail also does : not show any update, insert or delete statements. Same here : Am I am missing something here or is there some feature that : I need to turn on to make this work OR Is it that this : tool DB Audit does not support this feature. I have been : been trying for the past two days to see how this : tool performs and I simply cannot find out where to locate : the update, delete, insert statements. I have written several : sql scripts that I ran on SQL Server 2005, so that I can test : to see if DB Audit captured any of them But it only capture : the Drop, Create and Alter sql statements and it recorded : the number of inserts, delets and update made to a table, BUT : not the actual update, delete or insert sql statement. : Any other suggestions...
|