Link to home
Start Free TrialLog in
Avatar of stephi01
stephi01

asked on

How to tell when a row was last updated

What is the best way to find out when a row was last updated when I have read-only access to a DB?

ASKER CERTIFIED SOLUTION
Avatar of whittet
whittet

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
whittet,

his database is readonly so no matter when his row is going to update, field will not get update anyhow. I don't think so this is possible in this perticular case.
Avatar of whittet
whittet

The question clearly stated that only reading data was to occur.  My prior comment is intended to allow inspection of SQL 2005 configuration (i.e. DDL) to determine whether a particular datetime field was populated with the relevant time stamp.
whittet,

you are right indeed, I wasn't arguing that you were wrong, I just wanted to update Author that it is somehow not possible with any DMVs or anything else, if he has updated timestamp or other datetime field, he is not able to do so.
Avatar of Anthony Perkins
>>his database is readonly so no matter when his row is going to update<<
Actually, no.  The author stated they "have read-only access to a DB" which is not the same as the "database is readonly".

But unless they have some way of identifying when a row is changed it really does not matter.
Avatar of stephi01

ASKER

Thanks!