Re: SQL Server Transactions

On Tue, Mar 1, 2016 at 11:24 AM, Chris Davis chrisd@actongate.co.uk wrote:

If I start a SQL transaction and append records via a VFP View, issue a table update but don't COMMIT the transaction are these records available from another machine?

They could be, depending on how you set up the Transaction Isolation Level:

https://technet.microsoft.com/en-us/library/ms173763(v=sql.110).aspx

If they are how could I know that they have been appended in a transaction that may well end up getting rolled back?