?
Solved

SQL Server 2012 Express - Compatibility Level 110 not available

Posted on 2014-02-13
2
Medium Priority
?
1,533 Views
Last Modified: 2014-02-17
I am running SQL Server 2012 Express on a windows 8 laptop.  For some reason compatibility level 110 is not available and I want to know why.  

ALTER DATABASE AdventureWorks2012 SET COMPATIBILITY_LEVEL = 110
GO
Msg 15048, Level 16, State 1, Line 1
Valid values of the database compatibility level are 80, 90, or 100.
0
Comment
Question by:hojohappy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 2000 total points
ID: 39857727
Please open a new query and run :

Select  @@Version
Go

and post the results.

I suspect you have installed SQL Server 2012 Express on a machine that had a previous version of express on and hence you have only installed the SQL Server 2012 tools and are still running SQL Server 2008 instance.
You need to make sure you are upgrading the instance rather than just updating the tools.
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 39860966
May be you are using 2012 Management studio not a 2012 database engine.
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question