Database compat level 80 to 90 question

[katbear]

Hi,

Is there a FAQ somewhere that discusses what the ramifications are of changing the database compatibility level to 90 from 80?

Does the Upgrade Advisor catch all of these potential issues?

Thanks

 

[Jamfool]

sp_dbcmptlevel (Transact-SQL)



List some key points:

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

 

[katbear]

I was hoping if someone knows if running the Upgrade Advisor will catch db compat level issues?

 

[mrdenny]

I don't know if it will.

Off the top of my head I'm not aware of any system functions or key words which have been removed in compat level 90. I believe that it only adds features.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com