select
do.name, do.create_date, do.modify_date, po.create_date, po.modify_date
from Development.sys.objects do join Production.sys.objects po on do.name = po.name
where
do.type = 'P'
and
do.name not like 'asp%'
and
abs(datediff (hh, do.modify_date, po.modify_date)) > 2
and
do.modify_date > po.modify_date
order
by do.name
Thursday, October 24, 2013
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment