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 |
|
rajk
Starting Member
20 Posts |
 Posted - 2003-04-24 : 07:40:10
|
| I would like to know the date/time on which a SP is changed (kinda change history) or going the other way, I want to know all the SPs that were changed on a particualr day, in SQL Server.Thanks in advance. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-24 : 08:31:04
|
| If you create the SPs via scripts with a drop + create then the date is in sysobjects.If you do an alter or use enterprise manager then the change date is not recorded.You should get used to holding the SPs as scripts on disk and keeping them in sourcesafe then sourcesafe will give you the change date and the history.seewww.nigelrivett.comAdministering SQL Server Release Control==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Changes to an SP