public bool TxnNoSync { get; set; }

Public Property TxnNoSync As Boolean

public:
property bool TxnNoSync {
	bool get ();
	void set (bool value);
}

This means that transactions exhibit the ACI (atomicity, consistency, and isolation) properties, but not D (durability); that is, database integrity will be maintained, but if the application or system fails, it is possible some number of the most recently committed transactions may be undone during recovery. The number of transactions at risk is governed by how many log updates can fit into the log buffer, how often the operating system flushes dirty buffers to disk, and how often the log is checkpointed.