1 out of 3 rated this helpful Rate this topic

Database Compatibility Level Option

SQL Server 2008 R2

SQL Server 2008
SQL Server 2005

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.

Note
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? Yes No

Not accurate

Not enough depth

Need more code examples

(2000 characters remaining)

Community Content Add

FAQ