Of course, it ended ten years before Grandstand did. According to Genome, the last regular edition aired on 30 April 1997, and the last edition of all aired two weeks later - live coverage of that year's Cup Winners' Cup final between Barcelona and PSG. It seems to have ended rather quietly, too - did Des make any reference to its impending demise during either edition?
Its demise was announced earlier, around November 1996, because in Giles Smith's book of reviews of sport on TV he makes reference to it having just been announced. Indeed, he says...
"Goodnight, Sportsnight. The BBC has announced that the programme will end in May 1997 and will then enter the garage for a complete strip-down and remoulding of the bodywork. Then it will re-emerge, at a different time of the week (possibly at flexible times) and be given a new name to indicate a radical and absolute break with the past. Something like Sports Tonight, perhaps."
In fact, that sort of happened because in the autumn of 1997 we had On Side which incorporated the more magaziney elements of Sportsnight, and that lasted a few years, and of course whenever there was football there would be Match of the Day in midweek. I think the loss of the FA Cup and England from 1997 was probably the final nail for Sportsnight, it meant they wouldn't have any regular midweek football.
The first time I ever wrote to the BBC was to ask where I could find a copy of the Sportsnight theme. Amazing piece of music.