Wither Defiant?

I haven’t followed Star Trek much since TNG went off the air, and I only caught part of the last episode of DS9, haven’t seen anything of Voyager since the second season, and haven’t seen any of the films since Generations (though I did catch part of First Contact and was glad I didn’t see the rest of it), and I’m kind of wondering what happened with the U.S.S. Defiant. I’m looking for canonical sources here, not novels.

I believe I once heard someone mention that the Defiant was destroyed in the last (or second-to-last) episode of DS9, but StarTrek.com’s library doesn’t say.

And what was wrong with First Contact? Sure, the Borg were pussified, but aside from that, I consider it one of the top 3 ST movies.

It totally wasted Gary Sinise, missed an opportunity at a priceless inside joke (that only Trekkies would have gotten), and was filled with lots of “Gee whiz” dialog.

Fromhere:
The Changing Face of Evil
Production 570
4/28/1999

“During a fierce battle with the Breen, the crew is forced to abandon ship. Although they escape unharmed, the Federation loses its Cardassian foothold — and the Defiant is destroyed.”

Gary Sinise was in ST: FC?

Zuh…?

He must be thinking Forrest Gump. I get ST and FG mixed up all the time.

Of course, two or three episodes later they get a second Defiant practically identical to the first, except for a different registry number.

[sub]
Picard: Mr. Gump, warp 9, engage!
Gump: I gotta pee.
[/sub]

When the original Defiant was destroyed, Starfleet authorised a replacement, the Sao Paulo, which was renamed the Defiant.

Well, it looked like Gary Sinise, some dude on the saucer section who gets attacked by the Borg and becomes one. (And manages to survive in a vacuum with a hole in his face plate.

As for the inside joke, when they’re getting ready to take off if the ship to use warp drive, dude starts freaking out because he can’t find something. Finally he finds it and jams it into the computer and a Steppinwolf song blasts forth. It would have been utterly hysterical if when he jammed the thing in there instead of playing Steppinwolf, if you’d have heard Shatner doing his rendition of Rocket Man. Dude could then shout, “Oh God that’s not it! I hate that guy!” (Or something similar.) and then jam in that Steppinwolf song. (Which was kind of annoying and out of place, IMHO.)