Great post!
For SQL Server 2005, I wrote a table valued function that implements a recursive CTE to return the entire dependency chain of given object. The code is published here: http://www.sqlserverandxml.com/2008/09/find-dependent-objects-recursively.html
Regards
Jacob Sebastian
