Thanks Sergey
Gerard



>>Hi.
>>Is there a way to View Transaction log files , or 'Roll Back' transactions from a Log File.
>>For instance , just did a "Delete from MyTable where 1=1 " in SSMS and it deletes all records. Now in VFP, I could recover deleted records , but in SQL the only way I can think of recovering them is possibly via Transaction Log.
>>
>>I cant see anywhere though where I can View Transactions Log or Recover deleted records .
>
>SQL Server does not provide means to recover deleted records or even easily view Transactions Logs. There're commercial 3rd party tools available (in no particular order):
>
>

http://www.lumigent.com/products/log_explorer.html
>

http://www.red-gate.com/products/SQL_Log_Rescue/index.htm
>

http://www.apexsql.com/sql_tools_log.asp