Cannot set SQL 2005 database to compatability level 80
Hi
Hoping someone can help. Due to old compiled code I am not able to amend a SQL query that wont run on SQL 2005+ (its currently working fine on SQL 2000 but the server and SQL needs to go :) )
I need to get compatibility mode to 80;
I've tried the following which returns an error saying the levels are only 90 upwards, any ideas please?
Neil
I've tried:
ALTER DATABASE corporateSET COMPATABILITY_LEVEL = 80GO
You can't set compatibility level to 80 in SQL 2012, it's just not supported.
See the matrix of what is supported here: https://msdn.microsoft.com/en-us/library/bb510680.aspx
Time to rewrite that code.