My favorite is probably Kyra Sedgwick as Brenda Leigh Johnson (The Closer)

Heather Locklear was not a detective...she was H.O.T., (and any excuse to put her "undercover" as a bikini beach girl was fine by me :rolleyes...but she was not a detective in grade.

And the name of the show certainly got a lot of laughs...