查看SQL Server的版本及License

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

select @@VERSION

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

SELECT SERVERPROPERTY('LicenseType') as Licensetype, SERVERPROPERTY('NumLicenses') as LicenseNumber,
SERVERPROPERTY('productversion') as Productverion,
SERVERPROPERTY ('productlevel')as ProductLevel,
SERVERPROPERTY ('edition') as SQLEditio;

LicensetypeLicenseNumberProductverionProductLevelSQLEdition
DISABLEDNULL10.50.4000.0SP2Enterprise Edition (64-bit)