• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

compatability level for SQL R2

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
25112
Asked:
25112
  • 2
1 Solution
 
Kyle AbrahamsSenior .Net DeveloperCommented:
100 is 2008, 105 is 2008 R2
0
 
25112Author Commented:
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
 
Kyle AbrahamsSenior .Net DeveloperCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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