MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for SQL Server


 

Isolation Levels in SQLOLEDB

Microsoft® SQL Server™ clients can control transaction-isolation levels for a connection. To control transaction-isolation level, the SQLOLEDB consumer uses the following elements:

SQL Server allows read-only access at the dirty read isolation level. All other levels restrict concurrency by applying locks to SQL Server objects. As the client requires greater concurrency levels, SQL Server applies greater restrictions on concurrent access to data. To maintain the highest level of concurrent access to data, the SQLOLEDB consumer should control its requests intelligently for specific concurrency levels.

See Also

"Isolation Levels" in SQL Server Books Online