trace flag 4199 and 9481

• abdalah.mehdoini

  Ten Centuries

  Points: 1012

  More actions

  July 11, 2019 at 7:37 am

  #3661860

  HEllo

  I am studying all the possibilities of having problems on a project of migration of SQL server 2008r2 TO  SQL 2016

  I would like to know what is the difference between the trace flag 4199 and trace flag 9481 thank you for your answers

  thanks

• Andrey

  SSC Eights!

  Points: 840

  More actions

  July 11, 2019 at 7:54 am

  #3661864

  In case of SQL2016 read the following article

  https://www.sqlrx.com/sql-2016-sp1-use-hint/

  Also, take into account that the same behavior can be got using database scoped config changes instead of turning traceflags for the whole server.