Post reply

SQL2008 Database Audit only capture SQL statement ?

  • August 4, 2011 at 9:21 pm

    #254930

    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 ?

  • August 16, 2011 at 1:15 pm

    #1369282

    If you need to capture the actual rows that have been deleted or inserted, you can use Change Data Capture, since you're in Enterprise edition. I've had to implement that alongside of audit, since audit did not have that level of detail.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply