SELECT DISTINCT
    object_name(object_id) AS StoredProc
FROM sys.sql_dependencies
WHERE object_name(referenced_major_id) = @tableName;