Allows your application to use the snapshot isolation level if your Microsoft SQL Server database is configured for Snapshot isolation. Supported only for Microsoft SQL Server 2005 and higher.
See "Using the Snapshot Isolation Level" for details about using the snapshot isolation level.
Valid Values
0 | 1
Behavior
When set to 1 (Enabled) and your application has the transaction isolation level set to serializable, the application uses the snapshot isolation level.
When set to 0 (Disabled) and your application has the transaction isolation level set to serializable, the application uses the serializable isolation level.
This option is useful for existing applications that set the isolation level to serializable. Using Snapshot Transactions in this case allows you to change to the snapshot isolation level with no or minimum code changes. If developing a new application, you can code it to set the connection attribute SQL_COPT_SS_TXN_ISOLATION to the value SQL_TXN_SS_SNAPSHOT.
This connection option can affect performance.