>Hi All:
> What are the steps that would allow me to give the developers at the remote location the ability to copy the data files from my office on sql server 7.0. I.E. the remote location is Texas and I want the people in Texas to go into the server here in cleveland and copy the data files and not the data itself into their server. The process of copying data is through FTP. Also if the folks in Texas are using SQL6.5 or 2000 would that create a problem in transfering the data since I am using SQL 7.0. ?
>Thanks

Going back to 6.5 could create problems for the other developers. For example, unicode data types nchar, nvarchar and ntext are not available in 6.5. Moving up to 2000 should not be a problem.

If you have 7.0, look in the books online under "What's New" for other potential problems of moving a db to 6.5.