if you have access to your remote sql server then you can add your remote sql server as a LINKED SERVER on your local database server.

Then to access your tables...

quote:

---

try File System Object in Stored Procedure

i used File System Object to Move one folder to another location with some different name....