McCammon's name was added to the Stanley Cup in 2002 with Detroit.
This sentence implies that McCammon was a player on the Detroit team when they won the Stanley Cup in 2002, and his name was added to the trophy as a result.