Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Posts
    12

    Unanswered: Last time a table/procedure was changed

    Hi..

    I'm trying to get all table/procedure changed since a chosen date.
    I need to know when a table or procedure was dropped/altered last time.
    Is there any catalog table that stores this information? I didn't found it.

    There is any other way?

    Thanks and my best regards,

    Fernando Almeida

  2. #2
    Join Date
    Jul 2009
    Posts
    12
    Ok..

    For the tables I found, that I can query systables like this:

    select tabname, created from systables where created > '2011-08-30' order by created desc

    However, still not able to do the same with procedures.

    Regards,

    Fernando Almeida

  3. #3
    Join Date
    Jul 2009
    Posts
    12
    Ok, once again. I've googled a little bit more, and I found this link.

    Based, in the post from the above link, I can't do it. Neither I have that kind of information, in the document section, neither the sysprocplan query was helpful (I guess they updated statistics).

    Anyway, I hope this information, can help someone in the future.

    Best Regards,

    Fernando Almeida

Tags for this Thread

Posting Permissions

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