Thursday, October 24, 2013

What's a more recent stored procedure, Development or Prod?

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

No comments:

Post a Comment