• 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

    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/