Questions tagged [compatibility-level]

Compatibility level is a SQL Server feature on the database level that can be used to make a database behave like it would be running on an older version of SQL Server than it actually is.

Filter by
Sorted by
Tagged with
0
votes
2answers
8k views

Oracle alternative edition for Windows Server 2012

Does Oracle 11.2 support Windows Server 2012? Any alternative for Windows Server 2012 with respect to Oracle editions? I checked in internet but their forums, and this question says its not ...
2
votes
1answer
2k views

Mysql compatibility between client and server of different versions

How to know what version of mysql client is compatible with what version of the server? Is there backward or forward compatibility tables from the client and/or server point of view? For a given ...
47
votes
2answers
39k views

What is the actual behavior of compatibility level 80?

Could somebody provide me with a better insight about the compatibility mode feature? It is behaving different than I expected. As far as I understand compatibility modes, it is about the ...
3
votes
1answer
1k views

Will certain Database Compatibility cause performance degradation?

I'm running a variety of SQL Servers from 2005 to 2012 across several machines. I have many of these databases running in SQL Server 2000 compatibility mode. Will using an older compatibility in a ...
11
votes
2answers
19k views

Restore database from backup file of different version / edition

I read that it's possible to restore a database in SQL Server as long as you're restoring from an older version to a newer version, for backwards compatibility reasons. Does anyone know off hand if ...
3
votes
1answer
596 views

SQL Server 2008 and compatibility level 80

Is there any technical reason why an application certified on SQL Server 2000 should not work properly on SQL Server 2008 with compatibility level 80? In other words would there be any possible data ...
6
votes
2answers
5k views

How to detect compatibility errors - SQL Server 2012

I am changing a database's compatibility mode from 90 (SQL Server 2005) to 110 (SQL 2012) and I am wondering at what point would I see errors from breaking changes if there are any. I ran Upgrade ...
3
votes
1answer
8k views

How can I query the SQL Server Compatibility Level into a variable?

I know to query the current Compatibility Level of a database with declare @dbname sysname select @dbname = db_name(0) exec sp_dbcmptlevel @dbname But this seems to return its result via print and I ...
4
votes
2answers
2k views

Does the compatibility level for sql server work reliably for scripts?

We have some DB scripts that need to be migrated from SQL Server 2008 R2 back to 2005, often scripts created in SQL Server 2008 / 2008 R2 won't run on a SQL Server 2005 installation (which some ...
7
votes
2answers
23k views

What is the meaning of Microsoft Compatibility Level?

Setting cmptlevel to 80 on a SQL-Server 2005 inhibits the use of PIVOT and APPLY, but doesn't affect the use of Analytical Functions. Is there any rational behind this?
32
votes
6answers
22k views

Make SqlClient default to ARITHABORT ON

First things first: I'm using MS SQL Server 2008 with a database at compatibility level 80, and connecting to it with .Net's System.Data.SqlClient.SqlConnection. For performance reasons I've created ...