Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Developer's Guide

- Previous: No Support for lock-when-loaded on Sybase and DB2
- Next: Chapter 8 Developing Java Clients

## Set RECURSIVE_TRIGGERS to false on MSSQL

For version consistency triggers on MSSQL, the property `RECURSIVE_TRIGGERS` must be set to `false`, which is the default. If set to `true`, triggers throw a `java.sql.SQLException`.

Set this property as follows:

    EXEC sp_dboption 'database-name', 'recursive triggers', 'FALSE'
    go

You can test this property as follows:

    SELECT DATABASEPROPERTYEX('database-name', 'IsRecursiveTriggersEnabled')
    go

- Previous: No Support for lock-when-loaded on Sybase and DB2
- Next: Chapter 8 Developing Java Clients

- © 2010, Oracle Corporation and/or its affiliates