Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1560
  • Last Modified:

SQL Server 2012 Express - Compatibility Level 110 not available

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
hojohappy
Asked:
hojohappy
1 Solution
 
Paul JacksonCommented:
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
 
Alpesh PatelAssistant ConsultantCommented:
May be you are using 2012 Management studio not a 2012 database engine.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now