[Solved] Is there a log in SQL Server where I can read what commands have been executed?

Duplicated question (I guess)

Looking for a SQL Transaction Log file viewer

You can use third party software to read transaction logs.

• http://www.red-gate.com/products/dba/sql-log-rescue/
• http://www.apexsql.com/sql_tools_log.aspx
• http://www.toadworld.com/products/toad-for-sql-server/w/wiki/10586.log-reader.aspx

And if you want to audit truncate command try to audit all commands executed on your database.

http://www.databasejournal.com/features/mssql/article.php/3861791/Database-Level-Auditing-with-Microsoft-SQL-Server-2008.htm