Stack Overflow
Stack Overflow

Questions tagged [compatibility-level]

22 questions
4
votes
1 answer

What is the Type System Version (Compatibility Level) for SQL Server 2012

What Type System Version (Compatibility Level) token can I specify in ADO.NET connection string to indicate that only SQL Server 2012 is supported?
abatishchev
  • 98,240
  • 88
  • 296
  • 433
4
votes
5 answers

Should I change my upgraded database's compatibility level from 8 to 9?

I am planning to upgrade a SQL Server 2000 instance to a SQL Server 2005 instance. I am not going to change any database code, so I won't be taking advantage of any SQL2005 specific syntax. Is there any reason to set my compatibility higher (to…
willem
  • 25,977
  • 22
  • 75
  • 115
3
votes
1 answer

How to check safety of changing SQL Server database compatibility level?

I recently took over a SQL Server running SQL Server 2012. One of the databases is running at compatibility level 90 (SQL Server 2005). I've learned that the database originated on a 2005 server and was migrated over. The developers are claiming…
Ben Wyatt
  • 399
  • 4
  • 14
2
votes
0 answers

mssql-jdbc datetime java type is converted to datetime2 in compatible SQLServer 2014 vs SQLServer2016

We are using SQLServer 2012-2016. DATETIME data type is part of the key in many tables. when we execute query with jdbcTemplate.query(query, queryParams, resultSetExtractor) What is send to SQLServer is : sp_executesql N'SELECT * FROM…
Ida Amit
  • 1,411
  • 2
  • 13
  • 27
2
votes
1 answer

SQL Server : database compatibility_level after upgrade

We are currently upgrading few SQL Server instances from SQL Server 2008 R2 to SQL Server 2012. This is a temporary solution (because Microsoft EOL support for 2008 R2 is coming soon). I noticed that after the upgrade all system database EXCEPT…
Yossi M
  • 61
  • 10
2
votes
1 answer

sql server compatibility full text stoplists and noise words

if I am running sql server 2008 in compatibility level 90 (sql 2005) does it use the stoplist in the resource database or does it use ftdata\ENU.txt files??? also if I make my own stoplist in 2008 (using compatibility 100) can I ignore the system…
Paul
2
votes
1 answer

How can I set compatibility level 80 in SQL Server 2012?

When I try to set compatibility level to 80 in SQL Server 2012: ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = 80; I get the following error: Msg 15048, Level 16, State 1 Valid values of the database compatibility level are 90, 100, or…
user3085553
  • 63
  • 3
  • 4
1
vote
1 answer

STRING_AGG working on compatibility level < 140

I understand STRING_AGG is introduced in SQL Server 2017 which is compatibility level 140. The expected behaviour is to get error message 'string_agg' is not a recognized built-in function when run on 2016 or lower versions. Got error when I run on…
dejjub-AIS
  • 1,501
  • 2
  • 24
  • 50
1
vote
2 answers

OPENJSON in compatibility level 100 SQL SERVER 2016

I need to use the functionality of OPENJSON() in an old database with compatibility level 100. The server runs SQL SERVER 2016. So i came up with this idea: Create another DB "GeneralUTILS" (lvl 130) in the same server and call this function from…
Felipe Rodriguez Herrera
  • 390
  • 2
  • 9
1
vote
1 answer

Can switching compatibility level from 100 to 130 lead to locking or deadlock problems?

We are currently testing a switch to compatibility level (cl) 130, up from 100, in our development environment (sql server 2016). After the switch we noticed some errors: could not execute batch command.[SQL: SQL not available] Transaction (Process…
1dlopez
  • 11
  • 2
1
vote
0 answers

Why is this allowed: create database [MyExample] with compatibility_level = 100

In SQL Server, the following executes with no error: create database [MyExample] with compatibility_level = 100; -- runs! why? It creates a database all right, but it does not set its compatibility level. Why is that syntax allowed then? In…
Jeppe Stig Nielsen
  • 60,409
  • 11
  • 110
  • 181
1
vote
1 answer

How to adjust Compatibility Level after database restore?

We have a few SQL servers. with different version i.e. 2005, 2008, 2012, 2014. (we plan to move away from 2005 soon). Many times our DBA will simply backup and restore a "template" client database to create a "new" database from the restored…
zig
  • 4,524
  • 1
  • 24
  • 68
1
vote
1 answer

Can I force Linq to Sql to use Sql2005Provider

This query (or rather one similar to it) is in a codebase we have already deployed. var timeblocks = from tb in DB.TimeBlocks where tb.StartDate.Date.AddDays(1) <= DateTime.Today select tb.Id; DB is a datacontext that connects to the…
Ej.
  • 321
  • 1
  • 3
  • 4
1
vote
1 answer

Consequences to setting the db compatibility level to SQL Server 2000

We have a Sql Server 2005 DB. For whatever reason, the compatibility level (e.g. via sp_dbcmptlevel) is set to 80 (which is Sql Server 2000). What are the consequences of that? Is there a performance penalty for my apps because of it?
AngryHacker
  • 59,598
  • 102
  • 325
  • 594
1
vote
1 answer

Migrating database to SQL Server 2008, maintaining compatibility level 80 - issues?

I need to migrate the database in a vendor-supplied client-server application to SQL Server 2008. The version of the application we run is supported on SQL Server 2000 SP4 and SQL Server 2005 SP2, but not 2008 - the reason, however, is mainly…
sully10128
  • 11
  • 1
1
2