Monday, February 20, 2012

MSSQL Question

Is there a way to find out the last time a row was updated without creating a field to contain the timestamp?
Any help is greatly appreciated!
Thanks,
JeffAnyway you have to have field where it is possible to save last time of update. It could be datetime, varchar, etc. You can use trigger for saving data in this field or use sp during update.|||If this is a requirement you might look into a third party tool called Lumigent Log Explorer or Lumigent Entegra. www.lumigent.com

No comments:

Post a Comment