>I don't have SQL-server, but I have MSDE 2000 that comes with Visual Foxpro 7,
Make sure you apply either SQL Server 2000 SP3, or at least the security hotfixes you can find at
http://www.microsoft.com/sql, as soon as possible.
>Q. What is the easiest way of getting data (or a subset) from existing tables on the server network
>into my development environment. In VFP I can simply take copies of the databases (.dbc/.dcx/.dct),
>table (.dbf), index(.cdx), etc. files.
DTS is the easiest way, but without the Client Tools, it's not easy to set up (I think). Either order the 120-day eval CD and install Client Tools Only, or check the online help files to find the proper syntax for BACKUP/RESTORE.
>Q. Are SQL7 databases/tables compatible with MSDE 2000?
Yes, as far as I know.
You might want to ask on the SQL Server forum here as well, if you haven't already.