Last Modified Date for a Stored Procedure

[pankajv]

Is there a way by which I can find when a particular Stored Procedure is modified?

 

[tlbroadbent]

Sorry. SQL Server doesn't track that info. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[mukund]

Hi,
The following query would help you.

select name, crdate from sysobjects a where type ='p' order by crdate desc

-Mukund.

 

[rt63]

Mukund,

This will work only if you drop the procedure and then create it again but it will not work when you have changed the procedure with alter statement. An alter statement does not change the crdate in the sysobjects table.

RT