SQL Server Trace Flags from Trace Flag 168 to Trace Flag 274


Trace Flags in SQL Server are used to turn ON or OFF particular behavior. TraceFlags are used for variety of purposes like Logging extended information in to SQL Server errorlog, Troubleshooting or improving SQL Server Performance, Enabling certain features or functionality, etc.

Below are the SQL Server Trace Flags from Trace Flag 105 to Trace Flag 274

SQL Server Trace Flag 168 – In SQL Server 2005 or SQL Server 2008, On querying through a view that uses the ORDER BY clause, the result are still returned in random order. KB 926292

SQL Server Trace Flag 205 – Report when a stored procedure is being recompiled. This trace flag will write the a corresponding message to the SQL Server errorlog.

SQL Server Trace Flag 210 – Needed to enable fix for issue mentioned in KB 945892.

SQL Server Trace Flag 212 – Needed to enable fix for issue mentioned in KB 951184.

SQL Server Trace Flag 237 – Tells SQL Server to use correlated sub-queries in Non-ANSI standard backward compatibility mode.

SQL Server Trace Flag 242 – Provides backward compatibility for correlated subqueries where non-ANSI-standard results are desired.

SQL Server Trace Flag 246 – Derived or NULL columns must be explicitly named in a select…INTO or create view statement when not done they raise an error. This flag avoids that.

SQL Server Trace Flag 253 – Prevents ad-hoc query plans to stay in cache.

SQL Server Trace Flag 257 – Will invoke a print algorithm on the XML output before returning it to make the XML result more readable.

SQL Server Trace Flag 260 – Prints versioning information about extended stored procedure dynamic-link libraries (DLLs). For more information about __GetXpVersion().

SQL Server Trace Flag 274 – Needed to enable fix for issue mentioned in KB 949097.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *