title: How can I view SQL Server 2005 Transaction log file
body: <p>How can I view the SQL Server Transaction Log File (.trn)?</p>
  
  <p>I'd like to be able to look inside the trn file at the individual transactions. Some records were deleted from a database and I need to know when, how and by who.</p>
  
  <p>Thanks
  Neal</p>
  
  <p>Edit: I have .bak files from before and after the deletion, and .trn files from during. </p>
  
  <p>Edit (2010-11-16): Discussed at length here:
  <a href="http://www.sqlservercentral.com/Forums/Topic1019240-357-1.aspx" rel="noreferrer">http://www.sqlservercentral.com/Forums/Topic1019240-357-1.aspx</a></p>