>I just migrated from an SBS 2003 Network with SQL2000 to SBS 2011 with SQL 2008R2. I installed SQL 2008 R2 and did a restore from a SQL 2000 backup file. All my data is in SQL 2008 R2 by my remote views in VFP90 give me an update conflict when change something. I issue tablerevert and the requery and the change is actually there.
>
>I need to get this fixed as my internal app is now not functioning and I'm no SQL Admin.
>
>Thanks for any help.

Some ideas to try:

1) make sure you are using the right driver (in this case, sql server native client 10.5, I think).

2) set READ COMMITTED SNAPSHOT on (see MSDN for the how)

3) in the OTHER section of the connection string, set OTHER=Mars_Connection=yes;

hth,

Hank