This speaks to a bigger question I have at times. "What all uses this table?" It would be nice to know every SSIS package, .SQL file or stored procedure that uses it. We do still have some DTS packages and maybe a few 'Data Junction' processes. I know I can do certain things for each type of file I want to look at but it would be nice to have all that info in one place, like a table to search.

I started working on something a few years ago to do this, just can't get the time to finish it. Anyone else develop anything similar?