Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is it possible to enable session Trace Flags using startup options?

April 26, 2017enable flags Options possible session startup trace

0

Posted

Is it possible to enable session Trace Flags using startup options?

1 Answer

0

Posted

No. It is not possible to enable session level trace flags using –T startup option. The startup option is used only to enable global trace flags. 7. Example: how to enable the trace flag 3205 for a session? Execute the command DBCC TRACEON 3205 8. Example:how to enable the trace flag 3205 globally? Execute the command DBCC TRACEON 3205, -1. Note the extra parameter -1 which instructs to apply the trace flag globally. 9. Where can I read more information on Trace Flags?