Pinal Dave posted this great little SQL snippet to view most recent queries executed in SQL Server 2005.
deqs.last_execution_time as [Time], dest.text as [Query]
sys.dm_exec_query_stats as deqs
sys.dm_exec_sql_text(deqs.sql_handle) as dest
This is definitely a useful SQL snippet to see what's just happened when you're in a pinch.