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

(1500 characters remaining)

Community Additions

ADD

Manage Your Profile

|

Site Feedback