Hi Alec,

A small notice...

If you set ShareConnection to .F., then each VFP remote view, which use the conenction, open new connection.

MartiJ

>When you use Transactions on an SQL Server backend, does it matter if your remote views do not share a connection?
>
>DBSETPROP('V_ALERT','View','ShareConnection', .F.)
>
>Having remote views not share a connection is handy so that you don't have to test for a busy state on the connection, but when you setup a transaction using SQL pass-thru you must pass a connection ID. Thus, in order for your remote views to be properly handled by the transaction is it required that all those remote views be on the same connection?