Stored Procedure Modified Date

Question

Post reply

Stored Procedure Modified Date

esebasti

SSC Eights!

Points: 854
More actions
February 12, 2003 at 8:09 am

#357706

Hi, this may be a silly question but does anyone know how I find out the last modified date on a stored proc, In EM it only shows the created date, when I alter procs that date remains the same, there must be somewhere that it stamps a modified date.
Thanks
E...

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

No, There is no modified date unless you drop and re-create the sp.

Andy Jones, DBA Hall of Fame Points: 3641 More actions · Answer 2

Hi, see the following thread.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=9753&FORUM_ID=5&CAT_ID=1&Topic_Title=Stored%20procedure%20changed%20date&Forum_Title=Administration

Regards,

Andy Jones

.

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 3

I run a trace will modifying a procedure, but I coudn't find a modified date. I don't think it exists. Only the creation date appears in sysobjects

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 4

you can use the schema_ver column in sysobjects to identify that a new version was created, although you can't identify when. If you build a routine that checks to see if the schema_ver column changes which runs periodically, and report when the schema_ver value changes, then you might be close to identifying when a SP changed.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

esebasti SSC Eights! Points: 854 More actions · Answer 5

Thanks folks, I do require that any proc changes get updated in the header but you know how it goes, some times people are in a hurry and they no not update it. But anyhow I was just curious if there was an easy way of looking it up. thanks

E...