>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

--sb--