• Jacob Wilkins (7/1/2015)


    Welsh Corgi (6/30/2015)


    I do not see where this code is reading a Transaction Log?

    SELECT [Transaction Id], [Begin Time], SUSER_SNAME ([Transaction SID]) AS [User]

    FROM fn_dblog (NULL, NULL)

    WHERE [Transaction Name] = N’DROPOBJ';

    GO

    The fn_dblog function is what reads the log.

    Cheers!

    Thanks a lot. 🙂

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/