Wednesday, August 24, 2011

Get modified stored procedures and tables in sql server

SELECT name, type_desc,*
FROM sys.objects
WHERE (type = 'P' or type='U' or type='V')
order by modify_date desc

No comments:

Post a Comment