We help IT Professionals succeed at work.
Get Started
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:
message returned:
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 corporate
SET COMPATABILITY_LEVEL = 80
GO
message returned:
Msg 15048, Level 16, State 1, Line 3
Valid values of the database compatability level are 90, 100 or 110
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE