Get Modification Date of A Stored Procedure

[kim1]

Hi guys,

Can we have the modification date of a stored procedure?

I would like to list all the stored procedure that have been modified since a certain date.

Thank you for your help.

Kim

 

[RobertT687]

Try:
select name, crdate from sysobjects
where type = 'P'.

 

[kim1]

This is the creation date. I need the Modification Date. Do you think that it is possible?

Thank you very much. Kim

 

[RobertT687]

Stored procedures are usually dropped and re-created when being modified, so create date should be last modified date.

 

[kim1]

I did a test and the crdate field has not been changed.

Thanks

Kim

 

[tlbroadbent]

SQL Server does not track modification date.

SQL 2000 Enterprise Manager doesn't drop and create stored procedures. It issues an Alter Procedure command. Terry L. Broadbent - DBA
Computing Links:

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

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

 

[kim1]

Thank you very much for your confirmation Terry.

Kim