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