How to view transaction logs in SQL Server 2008 [closed]
You could use the undocumented DBCC LOG(databasename, typeofoutput) where typeofoutput: 0: Return only the minimum of information for each operation — the operation, its context and the transaction ID. (Default) 1: As 0, but also retrieve any flags and the log record length. 2: As 1, but also retrieve the object name, index name, page … Read more