>>>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
>
>Thanks for the reply. I have native client 10.0 (SQL Server 2008 R2) installed..didn't work
>In SQL Management studio i did
>
>alter database PreWelSQL
>set ALLOW_SNAPSHOT_ISOLATION ON
>
>and
>
>ALTER DATABASE PreWelSQL
>set READ_COMMITTED_SNAPSHOT ON
>
>still get update confict.
>
>Not exactly sure on how to do your last recommendation
Are you using a connection string or a DSN?