February 12, 2003 at 8:09 am
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...
February 12, 2003 at 8:37 am
No, There is no modified date unless you drop and re-create the sp.
February 12, 2003 at 8:38 am
Hi, see the following thread.
Regards,
Andy Jones
.
February 12, 2003 at 8:46 am
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
February 12, 2003 at 8:54 am
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
February 12, 2003 at 8:58 am
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...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply