Stored procedure modified date
-
Is there a way to find when (/who) modified stored procedure last time? Thanks
-
Ask them... unless they dropped it instead of altering it, there's no information available in the system tables.
-
I asked- silence. Thanks
-
Search in the articles for change management... time to implement it
. -
Hi, I know this thread is getting a bit old but I recently needed to know when a bunch of sp's were last modified. I found that Information_Schema.Routines has a last_altered column.
-
You are right Dave, it does. However, it does not appear to actually display what you would expect as all the dates in my last_altered column match the dates in the created column regardless of when they were last altered.
Shame!
-
Is this SQL 2005? I thought they fixed this but perhaps not.
In SQL 2000, there definitely is no way to determine this. I used to schedule a script to load a table with the currect crdates and versions and then check that. Each alter does change the base_schema_ver, but you don't know when it changes.
This (http://msdn2.microsoft.com/en-us/library/ms190324.aspx) says modified date in sys.objects should be accurate.
-
I thought I had found the same problem with it not correctly showing the last altered date. What was pointed out to me by a co-worker, was that I was using the SQL Server 2005 tools to access my 2000 db. In 2000 the last_altered definitely doesn't work, but if you convert your 2000 db to 2005, then alter the sp, then the last_altered is correctly updated.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply