XSolvo
Current user:   guest    Change     Preferences 
   List directory   History   Similar   Print version 
XSolvo 
   About XSolvo 
Articles 
html2xml 
tradufix 
TVProgramGrabber 
download 
Philosophy 
gallery 

Articles > Check if data changed by quering date columns data

 
rw-rw-r--   stga   wheel

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'


Reference Check if data changed by quering date columns data
http://www.xsolvo.com/Articles/CheckIfDataChangedByQueringDateColumnsData


Prev. query sp_who2   Performance analyzing of SQL Trace logs Next