One of my coworkers is working on a set of stored procedures, and changing the input parameters for one of them.

This will break any procedure that calls that one, so we need to find all those procedures. Right now, we manually call a dependency finder script that looks in system tables for procedures that reference the one we changed.

I was thinking it might be cool to put a trigger on a system table - when we change a stored procedure, we automatically recompile all the procedures that reference it, so we know when one of them breaks.

Is that possible in 2K8?