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/