Changing Compatibility Level from (80) to (90) in SQL Server 2005

• luissantos

  SSCertifiable

  Points: 7391

  More actions

  May 5, 2007 at 10:53 am

  #174016

  Hello Comunity

  I have a question about changing the compatibility level of database. In this moment the compatibility level i have is (SQL SERVER 2000 (80)).

  For using the function PIVOT in TSQL , i must use SQL SERVER 2005 (90).

  What kind of problems if i change the compatibility level to (90)?

  Do i must make any rebuild of database ??

  Many thanks

  Luis Santos

   

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  May 5, 2007 at 1:57 pm

  #704518

  I think you need to run some tests most updated Join code will break, the details is covered below.  Hope this helps.

  http://msdn2.microsoft.com/en-us/library/ms178653.aspx

  Kind regards,
  Gift Peddie