Is there some kind of auditing software that will look at all the
stored procedures and make a library of which fields (table columns)
are accesses where? Currently we have DB Artisan.

We have 1000 stored procedures (procs). Unfortunately many procs
don't use aliases, or use varying aliases for the same table.
Ex: Table A has columns a1, a2. Table B has b1, b2

We have queries like:

select a1,b2 from A,B ...
[can't readily see what field belongs to what table]

select xxx.a1 from A xxx
select yyy.a1 from A yyy
[varying alias names for the same table]


This makes it hard to know where A.a1 is accessed. The only way I
know of is to do a data base search for objects (procs & views) that
access "a1" and look at all of them. So if table C has a column named
a1 it will show up.


IS THERE ANY AUDITING SOFTWARE THAT CAN HELP ME?