décembre
2010
Un article de zinzineti
Info sur la version, l’édition, et … de SQL SERVER
SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion
,SERVERPROPERTY('ProductLevel') AS ProductLevel
,SERVERPROPERTY('Edition') AS Edition
,SERVERPROPERTY('EngineEdition') AS EngineEdition
,SERVERPROPERTY('InstanceName') AS InstanceName
,SERVERPROPERTY('IsClustered') AS IsClustered
,SERVERPROPERTY('IsIntegratedSecurityOnly') AS IsIntegratedSecurityOnly
,SERVERPROPERTY('IsSingleUser') AS IsSingleUser
,SERVERPROPERTY('LicenseType') AS LicenseType
,SERVERPROPERTY('MachineName') AS MachineName
,SERVERPROPERTY('NumLicenses') AS NumLicenses
,SERVERPROPERTY('ServerName') AS ServerName
,SERVERPROPERTY('SqlCharSetName') AS SqlCharSetName
,SERVERPROPERTY('IsFullTextInstalled') AS IsFullTextInstalled
,SERVERPROPERTY('Collation') AS Collation