Are the object name, operation type and column values for tables available for each operation?
The table name is always available if the auditing is done with a matching transaction log and database and if the table hasn’t been dropped since the operation in question. If the table was dropped its name will appear as UKNOWN(id) where id is the table’s id as recorded in the transaction log. If the table has been re-constructed after the drop then it is most likely has a different id and thus ApexSQL Log cannot retrieve its meta-data (name and column names and types). In this case you can use the “Old Table ID Mapping” feature to map the old table id to the re-created table id. For Schema (DDL) operations, the object name is always available. Operation type is always available, for both DML and DDL operations, as this is recorded in the transaction log. Column values are always available, provided that: • The corresponding table’s meta-data is available and matches the meta-data as it was at the moment of the operation. • ApexSQL Log has access to all transaction log data necessary
