The end to Berry's yearnings came on his arrival at Trafalgar in 1805, captain of . "Here comes that fool Berry! "Now" we shall have a battle," exclaimed Nelson. Berry had rather a reputation as a fighter, though perhaps not as a master tactician, "Captain Codrington of found some wry amusement in seeing Berry in the "Agamemnon" blazing away for all he was worth, apparently at friend and foe alike", notes Oliver Warner in "A Portrait of Lord Nelson". "It was typical of Berry's luck that, having long and restlessly awaited a new ship, he should have been given the "Agamemnon", before having the infinite happiness of joining Nelson on the eve of his greatest battle." After a close escape from capture on her outward voyage, the "Agamemnon" had no particular opportunities for distinction at Trafalgar, and escaped the mêlée without heavy losses, engaging with the "Santissima Trinidad" and Admiral Dumanoir's division in the closing stages of the fight. At the battle's close, Berry took to his ship's boat in order to speak to Nelson on the "Victory" but by the time he arrived Nelson had just died, an unfortunate piece of timing which Berry would regret for the rest of his life.