SQL Table Transaction Log


SELECT * FROM sys.sysobjects WHERE NAME = '<table name>'
SELECT * FROM ::fn_dblog(NULL,NULL) WHERE [Lock Information] LIKE '% record id %'

SELECT * FROM fn_dblog(null,null) WHERE AllocUnitName like '% record id %'
Select [Begin Time], [Transaction Name] from fn_dblog(null , null) where [Transaction Name] = 'Delete'


SELECT [Begin Time],
       [Transaction Name],
       [Transaction ID],
       [Operation],
       [Context],
       [AllocUnitName] 
FROM
       fn_dblog(NULL, NULL)
WHERE
    Operation = 'LOP_DELETE_ROWS' AND AllocUnitName like '%<table name>%'

No comments:

Post a Comment