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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-21 : 09:16:30
|
| Elias writes "Hi , Is there anyway to find out last modified date for a stored procedure. I tried on syscomments table but no luck. Is any other system table give this information. Thanks a lot for all your help. regards Elias " |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-21 : 10:42:51
|
| SQL Server doesn't maintain this kind of info. If you need to track this on your procedures, you should use some version control software like SourceSafe. You would keep all of the SPs in script files which you can check in and check out for editing, and VSS will track everything for you...last edited time, by who, and the entire revision history. |
 |
|
|
|
|
|
Last update date for SP