Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    23

    Question Unanswered: How do you get a report of table update frequency?

    Hi

    Is there any way of producing a list of tables with an indication of frequency of updates?

    Even a list of tables with a "last updated" column would be good...

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    What about a triggers?

  3. #3
    Join Date
    Feb 2004
    Posts
    23
    I'll see whether it is possible to do this on the production db. As there are *lots* of user tables and the db is approx 20G in size, I was hoping there is a less 'intrusive' way of telling...

Posting Permissions

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