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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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