不建议使用sp_dbcmptlevel后如何检查SQL Server数据库兼容性？ [英] How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?

问题描述

根据 sp_dbcmptlevel ，

According to BOL (SQL Server Books Online) on sp_dbcmptlevel,

此功能将在Microsoft的未来版本中删除SQL Server。不要在新的开发工作中使用此功能，请尽快修改当前使用此功能的应用程序。而是使用ALTER DATABASE兼容性级别。

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.

现在，我知道的唯一的TSQL检查数据库兼容性的方法是通过 sp_dbcmptlevel 。
据我所知， ALTER DATABASE兼容性级别 仅用于设置兼容性级别，而不获取信息。

Now, the only TSQL way I know of checking database compatibility is through sp_dbcmptlevel. As far as I know, ALTER DATABASE Compatibility Level is just for setting the compatibility level, not getting info.

获得兼容性级别而不使用GUI？

How should one to get compatibility level without using GUI?

推荐答案

select name, compatibility_level , version_name = 
CASE compatibility_level
    WHEN 65  THEN 'SQL Server 6.5'
    WHEN 70  THEN 'SQL Server 7.0'
    WHEN 80  THEN 'SQL Server 2000'
    WHEN 90  THEN 'SQL Server 2005'
    WHEN 100 THEN 'SQL Server 2008/R2'
    WHEN 110 THEN 'SQL Server 2012'
    WHEN 120 THEN 'SQL Server 2014'
    WHEN 130 THEN 'SQL Server 2016'
    WHEN 140 THEN 'SQL Server 2017'
    WHEN 150 THEN 'SQL Server 2019'
    ELSE 'new unknown - '+CONVERT(varchar(10),compatibility_level)
END
from sys.databases

这篇关于不建议使用sp_dbcmptlevel后如何检查SQL Server数据库兼容性？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！