TechTalk

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