You didn't say that the first time!
I don't know of a way to iterate thru the x-act log (what about if it is dumped b4 you can read it?) but I'd query the system tables to find this.
I left my big poster of system tables and their relationships @ work, but if I recall correctly you can do something like this:
Of course, if you wish to actually track what changed and not just when they changed you're going to have to do something else. I guess what I'd do is something like this:
WHEN 'P' THEN "Stored Procedure"
WHEN 'U' THEN "User Table"
WHEN 'D' THEN "Index"
WHERE type != 'S' -- don't need to know for system tables
And store the stored procedure definition in there and perform a check every so often and if the date/contents differ create a new row. Same thing for views and such.
CREATE TABLE audit(
objectid int not null,
dateupdated datetime not null,
contents text not null,