Gail, thanks for all the help.

I played around with Apex SQL Log....the software's fine...in fact its very good.

The actual problem is something else. Sql Apex Log is only showing that data which I inserted into a table after I restored the backup on my server. That means its not reading the historical log and is only reading the log after I restored it on my server.

This is confusing me a little. The actual database on the production server was in Simple Recovery Model. So, I am assuming that when you restore a backup of a database that is in Simple Recovery Model the Transaction Log does not show the historical data. It starts from the time after the restore takes place.

Is that true??....