Technical Article

Determine when a Stored Procedure was created and last altered

,

Simply run this code with a specified stored procedure name or comment out the where clause to show all stored procedures.

select 
SPECIFIC_NAME AS procedureName, 
SPECIFIC_CATALOG AS databaseName, 
CREATED AS createDate, 
LAST_ALTERED as lastAlteredDate
from 
information_schema.routines 
where routine_name = '<Procedure Name Here>'

Rate

4.31 (13)

You rated this post out of 5. Change rating

Share

Share

Rate

4.31 (13)

You rated this post out of 5. Change rating