Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL2008 Database Audit only capture SQL statement

Author  Topic 

yhchan2005
Starting Member

26 Posts

Posted - 2011-08-04 : 22:51:27
Hi,

i am using SQL2008 Enterprise Edition and recently i have try to setup the Server Audit and Database Audit.

I have usng 1 table for test and found the Audit only capture the SQL statement which i have run. eg i issue delete statement to delete 10 record, the SQL audit only capture the statement, not the record which deleted. Same to Update statement, the original record is not capture as Audit record, just the statement, can someone help ?
   

- Advertisement -