Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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