How can I view the modified date of a stored procedure.
I am using SQL Server 6.5. I am able to get the date that a stored proc was
modified from the datemodified field in the systasks table.
However is it possible to get the modified date previous to this date...?
Also how can I find out what about the stored procedure has been modified
ie. enabled etc...?