I need to move the files base on the query from sql database. The files name is on the table, and I need to move these files to another sever. I was looking at this, http://www.sqlservercentral.com/Forums/Topic1514396-1351-1.aspx, which give me some idea. Anyone have examples, to passed the result from the sql query, and loop thru to move the physical files?