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 |
|
lcpx
Yak Posting Veteran
54 Posts |
 Posted - 2005-11-10 : 10:23:26
|
| Is there anyway I can see the last modified date of a particular table in MS SQL 2000?In the enterprise manager I can only see the create date.Thanks for your help. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-11-10 : 10:56:58
|
no there isn't.Go with the flow & have fun! Else fight the flow  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-11 : 00:04:09
|
| You need to maintain a document to record the changes you are doingMadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-11 : 02:08:43
|
| The create date will be that provided that each change causes the table to be dropped and recreated (or more correctly: Create TMP table with new structure; copy data from old table; drop old table; rename TMP table)You could also script out the database frequently (e.g. to a revision control system).But maybe there isa different solution - why are you wanting to do this?Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-11 : 02:11:47
|
| SQL Server 2000 doesn't offer this, but you'll be able to see this information along with auditing of all of the other objects in SQL Server 2005. The Management Studio tool, replacement for Enterprise Manager and Query Analyzer, even has a report that you can run to gather this information. They demonstrated this at PASS 2005.Tara Kizeraka tduggan |
|
|
|
lcpx
Yak Posting Veteran
54 Posts |
Posted - 2005-11-11 : 03:41:39
|
| The reason why I would like to know it, because there is one table contains all parameters data for our production system, but these days the system failed to work properly, so I suspect maybe the table had been updated inadvertly by somebody, but I am not sure, because the table contains too many parameters and nobody really understand them.Anyway thanks very much for your help! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-11 : 08:48:11
|
| Ah - so you are interested in changes to the data in the table, rather than the structure of the table?If you have transaction log backups you could examine them for changes to that table (using a 3rd party log reader from Red-Gate or Lumiscent), or you could restore to a temporary database log-by-log in STANDBY mode and query to see when the table changed (but laborious!)And for the future you could create a trigger on that table that copied any changes to an "audit" table (with LogonID, Date, etc.) so you can examine your audit after-the-fact next time something goes wrong.Kristen |
|
|
|
|
|
|
|
|
Is there anyway I can see the last modified date o