easy

I just wanted to share the easiest way to get the modified date from a stored procedure in SQL Server. You do it just by accessing the Procedures table.

SELECT	Name,
		Create_Date,
		Modify_Date
FROM	sys.Procedures
WHERE	Name = 'Animal_Update'