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 |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2007-04-04 : 12:36:29
|
| Guys,Is there a way to find out when a certain DB object (e.g. Stored procedure) was last modified?SYSOBJECTS table contains crdate and refdate fields. None of these, however, appear to tell me when when the object was last updated.Is there a way to find that out?Thanks a lot |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-04 : 12:37:50
|
| Try to search SQLTeam. This has been discussed numerous times not long ago.Peter LarssonHelsingborg, Sweden |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-04-04 : 14:03:16
|
| Thanks Peso and Brett.Yes, according to the following, it seems that 2000 does not allow it: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79750 |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
Kristen
Test
22859 Posts |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-04-07 : 15:12:58
|
| Thanks for the enlightment folks!Jezemine: I'll keep this in mind in case my company migrates to 2005.Kristen: Great links ... I'm currently reading and learning from them ... |
|
|
|
|
|
|
When was db object last updated?