Sweeney made his major league debut on August 4,, as the starting first baseman for the St. Louis Cardinals against the Chicago Cubs. He was hitless in four at-bats on his debut. He collected his first major league hit the next day against Cubs starterJim Bullinger. He hit his first home run on August 10 against the Los Angeles Dodgers' Hideo Nomo. He remained with the Cards until when he was traded to the San Diego Padres, along with Danny Jackson and Rich Batchelor, for Fernando Valenzuela, Phil Plantier and Scott Livingstone. He went 2 for 3 as a pinch hitter for the Padres in the 1998 World Series against the New York Yankees, making the last out of the Series by grounding out to third base. After the season, he was traded by the Padres, along with Greg Vaughn, to the Cincinnati Reds for Josh Harris, Reggie Sanders, and Damian Jackson. Sweeney spent one season with the Reds organization, much of which was spent with the Triple-A Indianapolis Indians. The Reds traded him on January 14,, to the Milwaukee Brewers, along with Gene Altman, for Alex Ochoa. He spent the next two seasons with the Brewers shuttling between the Majors and Triple-A while battling through an assortment of injuries and trips to the disabled list. In, he was traded by the Brewers with Lou Collier, Jeromy Burnitz, Jeff D'Amico, and cash to the New York Mets for Glendon Rusch, Lenny Harris, and Alex Ochoa. He failed to make the Mets roster and was released. The San Diego Padres signed him as a free agent a few days later. Had a poor season with the Padres, hitting just.169 in 48 games. Sweeney spent and with the Colorado Rockies, with the Padres, - with the San Francisco Giants and 2007 and with the Los Angeles Dodgers. He has played first base, outfield, and designated hitter. In 1,218 career games, he is a lifetime.254 hitter, with 42 home runs, 250 runs batted in, and 16 stolen bases. According to the New York Daily News in a story that broke in January 2007, Barry Bonds blamed a positive amphetamine test result during the 2006 season on a substance he took from Sweeney's locker. Sweeney's agent denied the claim that Bonds had gotten such a substance from Sweeney. Bonds would later clear Sweeney of any involvement in his positive amphetamine test. On July 27, 2007, against the Florida Marlins, he moved into a tie for 2nd place on the all-time pinch hits list with Manny Mota with a pinch hit single. On July 29, 2007, he moved into sole possession of 2nd place behind Lenny Harris on the all-time pinch hits list with a game-tying, pinch hit double to deep right field in the 9th inning that scored Dave Roberts. On August 9, 2007, Sweeney was traded to the Los Angeles Dodgers for second basemanTravis Denker. The trade was the first between the Giants and the Dodgers since. He remained with the Dodgers, primarily as a pinch hitter through the 2008 season. In May 2008, Sweeney surrendered his jersey number, 22, to his rookie teammate Clayton Kershaw, and adopted #21. Unable to find a playing position as a free agent for 2009, Sweeney officially announced his retirement on March 6, 2009. He subsequently rejoined the Dodgers organization as an assistant coach.
After baseball
In 2012, Sweeney began working as a baseball correspondent and pregame color analyst for Padres telecasts on Fox Sports San Diego. In the Fall of 2013, Sweeney's number 12 will be retired by his alma mater, the University of Maine. In 2014, Sweeney started appearing on FOX and FOX Sports 1 as a studio analyst. Sweeney is married to fitness instructor Cindy Whitmarsh, with whom he has a son and two stepdaughters.