How can I view SQL Server 2005 Transaction log file

sql-server-2005 analysis transaction-log
Neal Hudson picture Neal Hudson · Nov 11, 2010 · Viewed 12.8k times · Source

How can I view the SQL Server Transaction Log File (.trn)?

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.

Thanks Neal

Edit: I have .bak files from before and after the deletion, and .trn files from during.

Edit (2010-11-16): Discussed at length here: http://www.sqlservercentral.com/Forums/Topic1019240-357-1.aspx

Answer

Preet Sangha picture Preet Sangha · Nov 11, 2010 
Select * from ::fn_dblog(null,null)

Is a virtual table over the log

Related questions

Analysis Services Only Windows Authentication

Is it true that Analysis Services ONLY supports windows authentication?

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More
Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More