Trace flags

The dbcc traceon option allows the system administrator to turn on trace flags within Component Integration Services. Trace flags enable the logging of certain events when they occur within Component Integration Services. Each trace flag is uniquely identified by a number. Some are global to Component Integration Services, while others are spid-based and affect only the user who enabled the trace flag. dbcc traceoff turns off trace flags.

The syntax is:

dbcc traceon (traceflag [, traceflag...])

Trace flags and their meanings are shown in Table 3-1:

Table 3-1: Component Integration Services trace flags

Trace flag



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.