coder
Reputation:
Snapshot Isolation
Does anyone know which versions of sqlserver2008 supports snapshot isolation?
Upvotes: 3
Views: 460
Answers (1)
Godeke
Reputation: 16281
Snapshot Isolation was added in SQL 2005 and is not dependent of the SKU of 2005 or 2008 for that support. Even SQL Express (2005/2008) supports the feature.
ALTER DATABASE DatabaseName
SET ALLOW_SNAPSHOT_ISOLATION ON
Upvotes: 4
Related Questions
- Are there any drawbacks to turning on ALLOW_SNAPSHOT_ISOLATION
- SQL Server snapshot isolation level issue
- Using Snapshot Isolation level in a SQL Server View
- Snapshot isolation in SQL Server
- Set Snapshot isolation is not reflecting
- What are the user permissions needed to enable snapshot isolation in a DB?
- Read Committed Snapshot Isolation and Transactions
- Snapshot transaction Isolation levels: it really works as advertised?
- TSQL Snapshot Isolation
- SQL Snapshot Isolation limits