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 |
|
CanadaDBA
583 Posts |
 Posted - 2005-05-24 : 10:00:15
|
| Can I find a stored procedure is updated or not? Is there anywhere recorded the stored procedure's last update?Canada DBA |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-05-24 : 10:01:09
|
| It's not recorded.-------Moo. :) |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-05-24 : 12:20:54
|
| When a stored procedure is updated? You mean the last time the definition of the stored procedure was changed? If you use the DROP/CREATE method of updating, then you can check the CreateDate. But if you're using ALTER, then we had a previous post about this, but I can't seem to locate it right now.EDITUhhh... Never mind. I found it, a reference to Last_Created in the INFORMATION_SCHEMA.ROUTINES view, but unfortunately, there's a bug where that just shows the date Created, not last Altered.---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
Is last update recorded?