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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
>>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.
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.
ASKER
Thanks!
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.