The trace flags values used with sp_traceon.
| Value | Description |
|---|---|
| 1 | Logs start-up information. |
| 2 | Logs connection information. |
| 3 | Logs language event processing. |
| 4 | Logs RPC event processing. |
| 5 | Logs cursor event processing. |
| 6 | Logs dynamic event processing. |
| 7 | Logs bulk events. |
| 8 | Logs messages sent to client. |
| 9 | Logs interaction with Oracle RDBMS. |
| 10 | Logs information contained in TDS login record. |
| 11 | Logs all DONE packet processing. |
| 12 | Forces shutdown. |
| 13 | Traces XA (ASTC, DTM) RPCs. |
| 14 | Enables XA LIB tracing. The output is written to <install_dir>/DCO-15_0/rdbmd/log/xa_servicenameDate.trc. |
| 15 | Logs parser errors. |