DECLARE @DepTree TABLE (ObjNum int identity(1,1) not null, Name varchar(1000), DependsOn varchar(1000), ObjectType char(2), DepLevel smallint)

INSERT INTO @DepTree (Name, DependsOn, ObjectType, DepLevel)
SELECT DependsOn = S.Name, S.Name, ObjectType = S.XType, DepLevel = 0
FROM sys.sysobjects S
WHERE S.Name = 'ENTER_YOUR_OBJECT_NAME_HERE'

DECLARE @Name varchar(1000)
DECLARE @DependsOn varchar(1000)
DECLARE @DepLevel smallint
DECLARE @ObjNum int
SET @ObjNum = 1
WHILE EXISTS(SELECT 1 FROM @DepTree WHERE ObjNum = @ObjNum)
BEGIN
      SELECT @Name = Name, @DependsOn = DependsOn, @DepLevel = DepLevel FROM @DepTree WHERE ObjNum = @ObjNum

      -- this block finds objects that the current object of interest depends on (moving _down_ the dependency chain):
      IF @DepLevel >= 0
            INSERT INTO @DepTree (Name, DependsOn, ObjectType, DepLevel)
            SELECT DISTINCT S1.Name, DependsOn = S2.Name, ObjectType = S2.XType, DepLevel = @DepLevel + 1
            FROM sys.sysdepends DP
            JOIN sys.sysobjects S1 ON S1.ID = DP.ID
            JOIN sys.sysobjects S2 ON S2.ID = DP.DepID
            WHERE S1.Name = @DependsOn
            ORDER BY 1, 3, 2

      -- this block finds objects that depend on the current object of interest (moving _up_ the dependency chain):
      IF @DepLevel <= 0
            INSERT INTO @DepTree (Name, DependsOn, ObjectType, DepLevel)
            SELECT DISTINCT S2.Name, DependsOn = S1.Name, ObjectType = S2.XType, DepLevel = @DepLevel - 1
            FROM sys.sysdepends DP
            JOIN sys.sysobjects S1 ON S1.ID = DP.DepID
            JOIN sys.sysobjects S2 ON S2.ID = DP.ID
            WHERE S1.Name = @Name
            ORDER BY 1, 3, 2

      SET @ObjNum = @ObjNum + 1
END

SELECT * FROM @DepTree