David,

>Is there any problem working with remote views against SQL server in table buffering mode? Docs say pessimistic buffering is a no-no. Is there anything else I need to look out for?

Table buffering is perfectly fine, and you're right about pessimistic record locking...other than that you should be fine.

Regards,