SQL Server Performance

SQL2008 Database Audit only capture SQL statement ?

Discussion in 'SQL Server 2008 General DBA Questions' started by yhchan2005, Aug 4, 2011.

  1. yhchan2005 Member

    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 ?
  2. satya Moderator

Share This Page