Results 1 to 3 of 3

Thread: MSSQL Question

  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unanswered: 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,

    Jeff

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Anyway 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.

  3. #3
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    If this is a requirement you might look into a third party tool called Lumigent Log Explorer or Lumigent Entegra. www.lumigent.com
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •