/*
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
Showing posts with label stored procedure. Show all posts
Showing posts with label stored procedure. Show all posts
Tuesday, October 4, 2011
Find Modified Procedures,Functions,Views In SQL Server
Subscribe to:
Posts (Atom)