Query to get list Stored Procedures ordered by modified date

Getting list of stored procedures ordered by modified date can be useful to find recently modified sps

-- Queries the sys.objects system view to gather information

-- about user defined stored procedure database objects;

-- specified with type='P'.

-- order by modified date--

SELECT
FROM sys.objects -- User defined objects system view
WHERE type = 'P' -- Only return stored procedures
ORDER BY modify_date desc name, create_date, modify_date




Refer the following link on msdn for more information that you can get using sys.objects
http://msdn.microsoft.com/en-us/library/ms190324.aspx