SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Finding out the d/t a table was last written too		  Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jim77
Constraint Violating Yak Guru

United Kingdom
440 Posts
Posted - 07/03/2006 :  06:30:14  Show Profile
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
Flowing Fount of Yak Knowledge

United Kingdom
1074 Posts
Posted - 07/03/2006 :  07:28:31  Show Profile
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.
Go to Top of Page

Jim77
Constraint Violating Yak Guru

United Kingdom
440 Posts
Posted - 07/03/2006 :  08:31:59  Show Profile
Thanks for that Ryan that's what I was fearing worse than a pointed stick.
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22461 Posts
Posted - 07/03/2006 :  08:58:07  Show Profile  Send madhivanan a Yahoo! Message
You need to maintain a document to record the changes as soon as it is edited

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 07/03/2006 :  09:25:09  Show Profile
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
Go to Top of Page

Jim77
Constraint Violating Yak Guru

United Kingdom
440 Posts
Posted - 07/03/2006 :  10:38:16  Show Profile
cheers guys I feel this is going to be a overkill though
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 07/03/2006 :  13:15:01  Show Profile
"I feel this is going to be a overkill"

I'm not surprised ..... !
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts
Posted - 07/03/2006 :  21:36:40  Show Profile  Send jen a Yahoo! Message
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

--------------------
keeping it simple...
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000