compatibility mode

• mxy

  SSCarpal Tunnel

  Points: 4036

  More actions

  October 24, 2013 at 11:02 am

  #395723

  Do we need to run DBCC checkdb and update usage after changing compatibility mode.

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  October 24, 2013 at 11:03 am

  #1661392

  No.

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 24, 2013 at 1:31 pm

  #1661443

  The only thing compatibility mode affects is how the parser and query processor handle certain T-SQL constructs. It doesn't change the database in any way

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• mxy

  SSCarpal Tunnel

  Points: 4036

  More actions

  October 24, 2013 at 1:43 pm

  #1661448

  thanks