Check if data changed by quering date columns data
After a restore of transactions logs it's important to check if your database is "up to date". Try this query to get sqlstatement to be executed.
select 'select '''+so.name+''' as tbl, max('+sc.name+') as tmax from '+so.name
from syscolumns sc
JOIN sysobjects so
ON so.id = sc.id
where sc.xtype in (58,61)
and so.xtype = 'U'