Sets certain database behaviors to be compatible with the specified version of SQL Server.
This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use
ALTER DATABASE Compatibility Level instead.
Transact-SQL Syntax Conventions
sp_dbcmptlevel [ [ @dbname = ] name ]
[ , [ @new_cmptlevel = ] version ]
@dbname = ] name
Is the name of the database for which the compatibility level is to be changed. Database names must conform to the rules for identifiers.
name is , with a default of NULL. sysname
@new_cmptlevel = ] version
Is the version of SQL Server with which the database is to be made compatible.
version is , with a default of NULL. The value must be one of the following: tinyint
90 = SQL Server 2005
100 = SQL Server 2008
110 = SQL Server 2012
0 (success) or 1 (failure)
If no parameters are specified or if the
name parameter is not specified, sp_dbcmptlevel returns an error.
name is specified without version, the Database Engine returns a message displaying the current compatibility level of the specified database.
Only the database owner, members of the
sysadmin fixed server role, and the db_owner fixed database role (if you are changing the current database) can execute this procedure.
Did you find this helpful?
( 1500 characters remaining)
Thank you for your feedback