• Oups... sorry! I just tried on my SQL Server 2008.

    Just researched... so this should work on SQL Server 2005:

    SELECT OBJECT_NAME(object_id) referencing,

    OBJECT_NAME(referenced_major_id),

    *

    FROM sys.sql_dependencies

    Greets

    Flo