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

 SQL Server     sbo     Updated on Jan 11, 2014     VIKRAM     517   

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:

  Related Articles
SQL Server: Search for particular keyword in all procedures (or) Get list of procedures where particular keyword or table name is used
SQL Server: Difference between Stored Procedure and Function
SQL Server: Named Batches
  Recent Articles
SQL Server: Search for particular keyword in all procedures (or) Get list of procedures where particular keyword or table name is used
SQL Server: Difference between Stored Procedure and Function
SQL Server: Named Batches