Q
Problem solve Get help with specific problems with your technologies, process and projects.

Finding the latest altered date of a stored procedure

SQL Server expert Greg Low explains how to find the latest altered date of a stored procedure.

How can I find the latest altered date of a stored procedure?
On SQL Server 2000, this value isn't stored. You will see a column in the INFORMATION_SCHEMA.ROUTINES view that suggests that it's what you want but unfortunately, it always returns the creation date instead ie: the CREATED and LAST_ALTERED columns both always return the same value.

View questions and answers from all of our SQL Server experts here.

Dig Deeper on SQL Server Stored Procedures

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close