Purpose

For Microsoft SQL Server 2005 and higher and Microsoft Windows Azure SQL Database only. Allows your application to use Snapshot Isolation for connections.

This property is useful for applications that have the Serializable isolation level set. Using the SnapshotSerializable property allows you to use Snapshot Isolation with no or minimum code changes. If you are developing a new application, you may find that using the constant TRANSACTION_SNAPSHOT is a better choice.

Valid Values

true | false

Behavior

If set to true and your application has the transaction isolation level set to Serializable, the application uses Snapshot Isolation for connections.

If set to false and your application has the transaction isolation level set to Serializable, the application uses the Serializable isolation level.

Notes

  • To use Snapshot Isolation, your database also must be configured for Snapshot Isolation.

Default

false

Data Type

boolean

See also

Isolation Levels

Performance Considerations