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.
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... |
|
|
|
|
|