Mssql

Voilà une liste de commande mssql permettant d'avoir des informations précises sur la version, service pack.... de mssql

SELECT @@VERSION
SELECT Serverproperty('Edition') as SQLServer_Edition
SELECT Serverproperty('ProductLevel') as SQLServer_Level
SELECT Serverproperty('ProductVersion') as SQLServer_Version
SELECT Serverproperty('InstanceName') as SQLServer_Instance
SELECT SERVERPROPERTY('Collation') AS 'Collation' 
SELECT Serverproperty('Collation') as SQLServer_Collation
SELECT Serverproperty('IsClustered') as SQLServer_IsClustered
SELECT Serverproperty('IsFullTextInstalled') as SQLServer_IsFullTextInstalled
SELECT Serverproperty('IsIntegratedSecurityOnly') as SQLServer_IsIntegratedSecurityOnly
SELECT Serverproperty('LicenseType') as SQLServer_LicenseType
SELECT Serverproperty('ServerName') as SQLServer_ServerName