I may be wrong, but I thought the "Sport" button only affected the suspension. To change the transmission shift patterns, you need to put the transmission in "sport" mode by moving the transmission lever to the left.

__________________
2008 X5 4.8i, Jet Black, Tobacco Nevada leather & just about everything else (no vent. seats, no 3rd row)