I've managed to get to the bottom of the issue, it was related to how the remote field names were defined in UpdateNameList:

? cursorsetprop('Tables', 'dbo.TestTable')
? cursorsetprop('UpdateNameList', 'Field1 dbo.TestTable.Field1, Field2 dbo.TestTable.Field2, Field3 dbo.TestTable.Field3')
? cursorsetprop('KeyFieldList', 'Field1')
? cursorsetprop('UpdatableFieldList', 'Field2, Field3')
? cursorsetprop('SendUpdates', .T.)

When I browse ltResults I can now make changes to the data, which are then reflected on the remote SQL Server.

What trigger implicitly performs the update with VFP? I notice that if I move the record pointer that will issue the change, but is there any way I can control this and if so, what other options do I have? For example, will that update take place if I select (and subsequently work) on another table?

Additionally, how would I wrap up this code in a transaction that'd allow me to perform a tableupdate or tablerevert based on other conditions within my application?

Regards