Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

compatability level for SQL R2

Posted on 2014-04-29
3
Medium Priority
?
234 Views
Last Modified: 2014-04-30
I see the compatability shows 100 for SQL R2 in system tables.. but in documentaiton it says 105? why the confusion?

example:
http://msdn.microsoft.com/en-us/library/ms187928(v=sql.105).aspx

(v=sql.105)
0
Comment
Question by:25112
[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
3 Comments
 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 40030317
100 is 2008, 105 is 2008 R2
0
 
LVL 5

Author Comment

by:25112
ID: 40030347
please try this: it do not work

 create database test
 go
 select * from sys.databases where name ='test'
 go
 ALTER DATABASE test SET COMPATIBILITY_LEVEL =105
 go
drop database test
0
 
LVL 40

Accepted Solution

by:
Kyle Abrahams earned 2000 total points
ID: 40030470
Ah.

For that, 100 means some version of 2008:
http://technet.microsoft.com/en-us/library/bb510680.aspx

They don't distinguish in the implementation.  Not sure why.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

670 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