Sunday, September 9, 2007

object lastmodified date and time

select name as objectname,modify_date lastmodified ,
case when type_desc='SQL_INLINE_TABLE_VALUED_FUNCTION'
then 'inline udf' else type_desc
end as objecttype
from sys.objects
order by modify_date desc

No comments: