SQL Server Home
Denali - Transaction_Log Extended Event Returning Incorrect Data
12/14/2010 9:03:24 PM
User(s) can reproduce this bug
The transaction_log Event in Denali CTP1 Extended Events is returning incorrect information for the index_id, object_id, and transaction_start_time columns in its Event payload. The index_id and object_id do not correspond to the object or index being logged about, and the transaction_start_time is always '01/01/1600'.
SQL Server Denali CTP 1
Windows Server 2008 R2
Operating System Language
Steps to Reproduce
Run the Repro in the Attached Word Document and compare the results as shown in the screenshot.
Mismatch of information returned by XEvents and the fn_dblog function
Matching information for log information to transaction_log event.
to post a comment.
Please enter a comment.
on 2/8/2011 at 3:57 PM
Awesome news Kevin. Thanks for the update.
on 2/8/2011 at 3:46 PM
Thanks for your report, we've been able to fix this bug, so that it will not be in the shipping product.
on 12/17/2010 at 9:51 AM
Thanks for the report.
We've assigned this to an engineer to track down what's going wrong and find a fix.
to post a workaround.
Please enter a workaround.
Invalid Transaction_Log Event Data in Denali.docx
© 2014 Microsoft