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?
ALTER DATABASE corporate
SET COMPATABILITY_LEVEL = 80
Msg 15048, Level 16, State 1, Line 3
Valid values of the database compatability level are 90, 100 or 110