SQL Server: Get List of Stored Procedures with Created Date and Modified Date

Introduction:

In this article i will explain how to get list of Stored Procedures with Created Date and Modified Date in SQL Server.

Description:

In previous articles i explained about joinsBatchesStored procedureFunctionsDifference between Stored procedure and Function, and Triggers in SQL Server. Now i will explain how to get list of Stored Procedures with Created Date and Modified Date in SQL Server.

We can get list of stored procedure names with Created Date and Modified Date from particular database by using following ways:

Use Test
select    name as [Procedure Name], 
        create_date as [Created Date], 
        modify_date as [Modified Date]
from    sys.procedures

(or)

Use Test
select    name as [Procedure Name], 
        create_date as [Created Date], 
        modify_date as [Modified Date]
from    sys.objects 
where    type = 'P'

(or)

Use Test
select    ROUTINE_NAME as [Procedure Name], 
        CREATED as [Created Date], 
        LAST_ALTERED as [Modified Date] 
from    INFORMATION_SCHEMA.ROUTINES 
where    ROUTINE_TYPE = 'PROCEDURE'

Output: