Does anyone have any idea what this flag does? There is no reference to it on MSDN. It is not a part of the article that lists available trace flags in 2008.

There is a KB article that recommends that it is turned on to resolve a specific issue with SQL Server 2008 that we have run into, but we would like to at least know what this flag does before enabling it.


  • Seems that it's not to be documented, like many trace flags. I left a comment on the support page. Who knows... – splattne Jul 8 '09 at 13:35
  • I'm failing also. I left a comment, too, asking for explanation of the flag. Power in numbers, eh? – squillman Jul 8 '09 at 13:38
  • Me too :) – Kev Jul 8 '09 at 13:39

I managed to get an answer to this with the help of Jonathan Kehayias on the MSDN forums.

The traceflag disables an optimization in the query optimizer. The optimization caused the issue described in the KB article when you try to insert into a table by selecting from the table itself. As turning on the traceflag could result in a perf degradation, you only should use it if you run into the issue described in the KB article.

The thread discussing this is here.

  • +1 for the follow-up. Thx! – squillman Jul 8 '09 at 21:13
  • Top man ! – Kev Jul 9 '09 at 11:41

At a guess, I'm thinking this turns on the hotfix included in Cumulative Update 3 should your system encounter the specific issue described in the knowledge base article.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.