Solved

compatability level for SQL R2

Posted on 2014-04-29
3
232 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 500 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

752 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