Logs client connect events, disconnect events, and attention events. (global). Events sent to error log only.
Logs client language, cursor declare, dynamic prepare, and dynamic execute-immediate text (global). Text sent to error log only.
Logs client RPC events (global). Events sent to error log only.
Logs all messages routed to client (global). Messages sent to only the error log.
Logs all interaction with remote server (global). Interaction sent to error log only.
Logs file/directory processing steps. (global)
Logs text and image processing. (global)
Prevents the create index and drop index statements from being transmitted to a remote server. sysindexes is updated anyway. (spid)
Instructs update statistics to obtain only row counts rather than complete distribution statistics, from a remote table. (spid)
Prevents the drop table syntax from being forwarded to remote servers if the table was created using the create table at location syntax.
Prevents escape on underscores (“_”) in table names. (spid)
Prevents generation of column and table constraints. (spid)
Disables Component Integration Services recovery at start-up. (global)
Disables Quickpass. (spid)
Disables Quickpass. (global)
Makes cursors involving Component Integration Services tables updateable by default.
Disables constraint checking of remote tables on the local server. This avoids duplicate checking. Setting this trace flag on ensures that queries are not rejected by the quickpass mode because of constraints. (spid)
Disables alter table commands to the remote server when ON. This allows users to modify type, length, and nullability of columns in a local table without changing columns in the remote table. Use trace flag 11221 with caution. It may lead to tables that are “out of sync.” (spid)
Disables proxy table index creation during create existing table or create proxy_table command execution. If this flag is set on, no index metadata is imported from the remote site referenced by the proxy table, and no indexes for the proxy table are created. This trace flag should be used with care and turned off when no longer necessary. (global)
Disables proxy table mapping to RPCs.
Instructs Component Integration Services to use pre-Adaptive Server version 12.5.3 methods of gathering statistics data.
Allows connection information to be logged when a connection to a remote server fails.