/*
Below code is for SQL 2008
*/
SELECT 'EXEC sp_HelpText '+name, create_date, modify_date,type
FROM sys.objects
WHERE type in ('P','FN','V','TF')
AND DATEDIFF(D,modify_date, GETDATE()) < 10 --How old the object can be ?
ORDER BY modify_date
Tuesday, October 4, 2011
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment