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-05-08 : 09:48:26
|
| Jose Espin writes "How can I make a query to get all the objects that I modified in a certain date? or at least stored procedures and tables (design changes)Thank youJose" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-08 : 11:00:27
|
Unfortunately SQL Server doesn't internally track object modification dates, only create dates. If you use DROP/CREATE instead of ALTER, then creation date would work for you, but I don't think you do it that way  If you use a source control program like Source Safe you can keep all of this information in there, and not only track modification dates but also keep the entire history of your objects, and be able to roll back to a previous version. You can also lock down the source code to prevent unauthorized changes. It's a bit of work to get set up, but it's really the best way to do it, and once you start you'll never go back! |
 |
|
|
|
|
|
Last object updated