Enables or disables a trace flag on a local instance.
dbcc nodetraceon(trace_flag_number) dbcc nodetraceoff(trace_flag_number)
trace_flag_number – is the number of the trace flag you are enabling or disabling.
Enables trace flag 3604:
dbcc nodetraceoff(3604)
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
dbcc traceon and dbcc traceoff apply trace flags for the entire cluster, while dbcc nodetraceoff and dbcc nodetraceon apply trace flags locally.
