In the VFP Programmers guide there is a really good section on this that explains how the data types match and whole lot of other useful information relative to SQL Server.
The biggest hassle are dates. SQL Server does not have a Date data type, only a DateTime. If you don't want to display DateTimes, then depending on if your using SPT or Remote Views you need to deal with it. Also, I have run into a problem with "'" causing updates to fail because SQL Server delimits strings with the same character.
I have integrated workarounds for these problems in my base data classes. I use only SPT, so I don't know whether the same applies of Remote Views.
There is a 2 part series in a past issue of FoxTalk called 'Turn your VFP App Client\Server: A 12-Step Program'. It does a good job explaining what to look for when doing C\S with VFP. They are at
www.pinpub.com.
Charlie