Yeah, SG-1 was on a cable channel initially. Can't remember which one, only that I was surprised that all of a sudden breasts were being shown.
Sci-Fi channel has done a few smart things, like greenlighting BSG. What I find interesting is that these days network TV seems to be in love with SciFi, while the SyFy channel seems to be scared of it.