Home Library Learn Downloads Support Community
Sign in | United States - English | |
0 out of 1 rated this helpful - Rate this topic

Database Compatibility Level Option

SQL Server 2008

To set certain database behavior to be compatible with a specified earlier version of Microsoft SQL Server, use ALTER DATABASE SET COMPATIBILITY_LEVEL. The compatibility level affects the behavior only in the specified database and not the whole server.

NoteNote

In earlier versions of SQL Server, sp_dbcmptlevel is used to set compatibility level. sp_dbcmptlevel is deprecated.

Concepts

Using Options in SQL Server
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Database Compatibility Level Option

This option is used to determin which parsing routines to use on queries for the desired database.
See Also: http://blogs.msdn.com/sqlserverstorageengine/archive/2007/04/26/what-s-the-difference-between-database-version-and-database-compatibility-level.aspx

History
To save the bounce to the other topic...
COMPATIBILITY_LEVEL { 80 | 90 | 100 }

Is the version of SQL Server with which the database is to be made compatible. The value must be one of the following:

80 = SQL Server 2000

90 = SQL Server 2005

100 = SQL Server 2008

History