Birch Note 7-Xu SQL Server logging mechanism

1--sqlserver Logging mechanism 2--logging transaction time, but there is no guarantee to record the name of the user initiating the transaction, and not to record the initiator's program name!!! 3 Use AdventureWorks 4 CREATE TABLE A (a INT) 5 go 6 CHECKPOINT  --do a checkpoint to write the data and log to the drive 7 GO 8 BACKUP log AdventureWorks WIT H truncate_only 9 GO11 DBCC log (7,3), INSERT into a VALUES (1) go17 DBCC log (7,3) at @SPID20 SERT into a VALUES (+) go23 DBCC LOG (7,3) UPDATE a SET a=2 WHERE a=10026 GO

Birch Note 7-Xu SQL Server logging mechanism