Solved

SQL Server 2012 Express - Compatibility Level 110 not available

Posted on 2014-02-13
2
1,427 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
2 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 total points
Comment Utility
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
Comment Utility
May be you are using 2012 Management studio not a 2012 database engine.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now