Contents Index PREVENT_ARTICLE_PKEY_UPDATE option [database] QUERY_PLAN_ON_OPEN option [compatibility]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

QUALIFY_OWNERS option [replication]


Function 

Controls whether SQL statements being replicated by SQL Remote should use qualified object names.

Allowed values 

ON, OFF

Default 

The default in Adaptive Server Anywhere is ON.

The default in Adaptive Server Enterprise is OFF.

Description 

Qualifying owners in Adaptive Server Enterprise setups is rarely needed because it is common for objects to be owned by dbo. When qualification is not needed in Adaptive Server Anywhere setups, messages will be slightly smaller with the option OFF.


Contents Index PREVENT_ARTICLE_PKEY_UPDATE option [database] QUERY_PLAN_ON_OPEN option [compatibility]