Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Last_altered in INFORMATION_SCHEMA.ROUTINES

Author  Topic 

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2006-12-19 : 03:46:22
The system view INFORMATION_SCHEMA.ROUTINES lists all procedure and some other stuff in a given database and it has a column "Last_altered". Is it dependable?? Is this actually the date when a procedure was last modified? I've read several places that there is no dependable way to find this but the column name seems clear enough!

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-12-19 : 03:56:40
from my experience nope, unless I missed out something before I queried the view



--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -