On, Off

On

Off for Sybase Open Client and jConnect connections

Controls the Transact-SQL transaction mode. In Unchained mode (chained=Off), each statement is committed individually unless an explicit BEGIN TRANSACTION statement is executed to start a transaction. In chained mode (chained=On) a transaction is implicitly started before any data retrieval or modification statement.

• Compatibility options
• sp_tsql_environment system procedure
• Autocommit implementation details
• Using transactions
• chained connection property