How to use log to find data in sql 2008 query?

Hello,

Please advise me. How to use log in a sql 2008 query to find if there is data exist or not in temp table, select query, after insert etc. I have a big query and some time showing zero output so I want to find where is the problem occurring in the query.