Finding out the d/t a table was last written too

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.

All Forums

Old Forums

CLOSED - General SQL Server

Finding out the d/t a table was last written too

Author

Topic

Jim77
Constraint Violating Yak Guru

440 Posts

Posted - 2006-07-03 : 06:30:14

Hi there guys,I have a table with hardcoded margins that is updating our current datawarehouse the problem is these values are ages old is the a quick way to check when the last time this table was edited please.

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2006-07-03 : 07:28:31

Jim - The edit date for data in a table does not get recorded automatically. So unless there some column in the table with data which has captured this, you're out of luck, I'm afraid.

Ryan Randall
www.monsoonmalabar.com London-based IT consultancy

Solutions are easy. Understanding the problem, now, that's the hard part.

Jim77
Constraint Violating Yak Guru

440 Posts

Posted - 2006-07-03 : 08:31:59

Thanks for that Ryan that's what I was fearing worse than a pointed stick.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-07-03 : 08:58:07

You need to maintain a document to record the changes as soon as it is edited

Madhivanan

Failing to plan is Planning to fail

Kristen
Test

22859 Posts

Posted - 2006-07-03 : 09:25:09

With some effort you could get an approximation if you have backups going way WAY back.

Restore oldest backup

Restore next oldest backup, compare & log differences

Repeat!

(No need to restore all the backups, of course, you might choose to only restore one per month, or some other suitable "granularity")

Kristen

Jim77
Constraint Violating Yak Guru

440 Posts

Posted - 2006-07-03 : 10:38:16

cheers guys I feel this is going to be a overkill though

Kristen
Test

22859 Posts

Posted - 2006-07-03 : 13:15:01

"I feel this is going to be a overkill"

I'm not surprised ..... !

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-03 : 21:36:40

you can try to check the reports generated (or some other table where you can get the info) and look for 'old' data and retrieve the date from there