Find Last updated stored procedures

by Behlul 11. January 2011 10:36

SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P' order by modify_date desc

17b754ba-639c-4ab0-9a49-ca6c9830c812|0|.0

Tags:

Improve Stored Procedure PerformanceSometimes even the simplest things can make a difference. One of these simple items that shoul...Drop All Procedures SELECT 'Drop Procedure ' + SCHEMA_NAME(schema_id)+'.'+name FROM sys.procedures TSQL left join and only last row from rightSELECT post.id, post.title, comment.id, comment.message FROM post OUTER...

Thank you