FIND CREATED AND LAST MODIFIED DATE OF A STORED PROCEDURE

You can find the details about these things in sys.objects table.

It is very helpful in finding when was the last time the stored procedure is modified.

Please see the example below.

USE HRMS;

SELECT NAME AS ‘Stored Procedure Name’,
CREATE_DATE ,
Modify_Date ,
type_desc
from sys.objects
WHERE TYPE = ‘P’ AND is_ms_shipped = 0 AND NAME = ‘aesp_AddLeaveBalance’

Also visit Select * from sys.objects for further details.

Pawan Kumar
Pawankkmr@hotmail.com