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

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

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