sundaridevi - 7:22 pm on Sep 19, 2011 (gmt 0)
If Google honors your take down request the offending site (or page) will be removed from Serps and it will be replaced by a notification saying something like, some results have been removed due to [take down request]. I've seen pages like that from time to time. For search engines, the take down doesn't have anything to do with whether or not they use google (or yahoo or bing) services, it is to comply with the safe harbor clause of the DMCA. For a host provider, it only works if they are hosted there.