var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Last time a table/procedure was changed
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,
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.
Ok, once again. I've googled a little bit more, and I found this
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.
Tags for this Thread