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 |
|
Mathias
Posting Yak Master
119 Posts |
 Posted - 2007-10-23 : 05:01:35
|
| I used to query sysobjects to find out what objects get changed over time. Nothing changes when I alter a store procedure for example. Any clue on find what sysobjects have been changed for the last 3 days?Thanks Paul |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-23 : 05:22:54
|
| "I used to query sysobjects to find out what objects get changed over time""Used to" being SQL 2000? Because back then it only ever recorded a Create Date, so an ALTER did not update the crdate column in sysobjects.Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-23 : 05:25:42
|
| http://dimantdatabasesolutions.blogspot.com/2007/08/objects-modified-date.htmlMadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-23 : 05:36:17
|
Also note that SQL Server 2005's sys.objects has modified_date as one of the columns  MadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-23 : 06:37:50
|
"sys.objects has modified_date"Although not quite the same as sysobjects that OP mentioned, so probably need more info about what the problem is that needs to be solved.Always worries me when people want the modify date of Database Object DDL; as iuit usually feels like the problem would be better solved by Version Control repository or somesuch  Kristen |
|
|
|
Mathias
Posting Yak Master
119 Posts |
Posted - 2007-10-23 : 10:24:53
|
| sys.objects contains now a modification and creation date that I can use to find out what has been modified since the last check.Thanks, Paul |
|
|
|
|
|
|
Find out what sysobjects have been updated