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 - 2004-01-07 : 08:06:41
|
| Chris writes "Hi,I have 2 databases, live and test. When I modify a SP in test I would like to see a modified date so I can keep track of what SP's I have modified so when I deploy a new software version I can check that the updated Db process has been successful. In enterprise manager there is a created date and in sysobjects table there is a crdate and refdate which always seem to be the same.Many thanks,Chris" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-01-07 : 08:09:11
|
| You need source control of some kind (CVS or VSS or whichever you prefer). Search the SQL Team forums for "source control" to learn more. This is the only true way to do what you want.Also get into the habit of scripting out your stored procedures and modify the script files. Editing procedures in EM is handy but will defeat your efforts to track and control versioning. Once the procedures are scripted to files, source control and version control are a piece of cake. |
 |
|
|
|
|
|
Stored Procedure modified dates