Wer mal einen Blick in das Transaktionsprotokoll werfen mag kann dies hiermit machen:
USE MEINE_DATENBANK;
GO
SELECT
[Current LSN],
Operation ,Context ,
[Transaction ID],
[Previous LSN],AllocUnitName,[Previous Page LSN],
[Page ID],[XACT ID],SUSER_SNAME(CONVERT(VARBINARY,[Transaction SID])) AS 'Login',
[Begin Time],[End Time]
FROM sys.fn_dblog (NULL, NULL);
Categories:
