Activity Logged for Databases with Transaction Logging

If a database uses transaction logging, all SQL data manipulation statements, except SELECT, against that database generate one or more log records. These statements are as follows:

• DELETE
• INSERT
• LOAD
• SELECT INTO TEMP
• UNLOAD
• UPDATE

If these statements are rolled back, the rollback also generates log records.