SQL Server View System log

Transferred from: http://bbs.csdn.net/topics/390903317

--step #1:
Use [Lowescampms.net_test]
GO
SELECT
[Transaction ID],
Operation,
Context,
Allocunitname

From
Fn_dblog (null, NULL)
WHERE
Operation = ' Lop_delete_rows ' and
Allocunitname= ' dbo. Vehicle.pk_vehicle '
--here ' dbo. Test.pk__test__5f573dd6 ' refers to the pk_name of the name of the table
--You can use Sp_pkeys SourceTableName to find

--step #2:
SELECT
Operation,
[Transaction ID],
[Begin time],
[Transaction Name],
[Transaction SID]
From
Fn_dblog (null, NULL)
WHERE
[Transaction id] = ' 0000:0010847e '--here ' 0000:0005afba ' means step #1中的Transaction ID
and
[Operation] = ' lop_begin_xact '

--step #3:
Use MASTER
GO
SELECT suser_sname (0x01) ' UserID '--here ' 0000:0005AFBA ' value step #2中的Transaction SID

SQL Server View System log