>Hi All, is it possible to copy or move files from within a sp ?, e.g. if I have a collection of files in \\myserver\myfolder , can I move or copy them to \\myserver\myotherfolder ?

You can use xp_cmdshell system sproc. See http://www.nigelrivett.net/SQLAdmin/s_CopyLatestBackup.html, for example.