This is certainly short and sweet. Please note that this is available only from SQL Server 2008 onwards.
Many years ago, I wrote a function that uses a recursive CTE and retrieves the dependency chain along with a hierarchical view of the dependency chain. You can find it here.
commented on Jul 5 2012 1:01AM