Disables snapshot isolation.
mlsrv11 -c "connection-string" -dsd ...
When the consolidated database is SQL Anywhere (version 10 or later) or Microsoft SQL Server (2005 or later), the default isolation level for downloads is snapshot isolation. If the consolidated database is an earlier version of these databases, the default download isolation level is read committed.
You can also change the default isolation level in a script. However, for SQL Anywhere version 10 and Microsoft SQL Server 2005 and later databases, the isolation level is set at the start of the upload and download transactions. This means that if you set the isolation level in the begin_connection script, it may be overridden in the begin_upload and begin_download scripts.
This option only applies to SQL Anywhere version 10 and Microsoft SQL Server 2005 consolidated databases.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |