Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » MobiLink - Server Administration » MobiLink Server Options

-ds option Next Page

-dsd option


Disables snapshot isolation.

Syntax

mlsrv10 -c "connection-string" -dsd ...

Remarks

When the consolidated database is SQL Anywhere (version 10 or higher) or Microsoft SQL Server (2005 or higher), 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 up 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.

See also