There are a lot of uses for this technique. Here is an example from Nigel Rivett for doing FTP in a stored procedure

http://www.nigelrivett.net/FTP/s_ftp_GetFile.html

he also has a clever way of writing format files for BCP in the same way. Naturally, one wouldn't give the normal application user any access to this!.