Setting Open Server trace flags

Use the srv_traceflags parameter to turn on trace flags to log Open Server diagnostic information. Open Server trace flags are described in Table 6-9.

Table 6-9: Open Server trace flags

Trace flag

Description

1

Traces TDS headers

2

Traces TDS data

3

Traces attention events

4

Traces message queues

5

Traces TDS tokens

6

Traces Open Server events

7

Traces deferred event queues

8

Traces network requests

For example:

sp_text_configure KRAZYKAT, ’srv_traceflags’, ’3’