All databases
syslogs contains the transaction log. It is used by Adaptive Server for recovery and roll forward. It is not useful to users.
You cannot delete from, insert into, or update syslogs. Every data modification operation is logged, so before you can change syslogs, the change must be logged. This means that a change operation on syslogs adds a row to syslogs, which then must be logged, adding another row to syslogs, and so on, producing an infinite loop. The loop continues until the database becomes full.
The columns for syslogs are:
Name |
Datatype |
Description |
|---|---|---|
xactid |
binary(6) |
Transaction ID |
op |
tinyint |
Number of update operation |
