SQL Stored Procedure

SQL – Find Last Modified Stored Procedure or Function

100 free redneck dating sites In this post, we will look into some of the useful SQL Queries.
Following SQL Query will be really helpful to find last modified stored procedure or function.

Binary options 60 seconds supportresistance strategy SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = ‘P’ or type = ‘fn’ or type IN (‘FN’, ‘IF’, ‘TF’);

http://www.beaujolais-challenge.com/?nikolsa=date-rencontre-psg-barcelone&bc5=6b If you want to show last changed item at first use Order By with modified_date desc,

see url SELECT name,create_date,
modify_date
FROM    sys.tables
ORDER BY modify_date DESC;