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-10.
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, with the Enhanced Full-Text Search engine, run the following:
sp_text_configure KRAZYKAT, ’srv_traceflags’, ’3’