sp_traceoff turns off trace flags for the current connection.
server_name... sp_traceoff [traceflags]
DCSERVER...sp_traceoff 2,3,4,5
If no trace flags are specified, all trace flags are turned off.