Binaryworld - Get SQL Server Details ( Edition , License ... etc ). ... [ SQL Server -> Server Operations ]

How to obtain details about the server using the new SERVERPROPERTY system function?

SELECT CAST( SERVERPROPERTY( 'MachineName' ) AS varchar( 30 ) ) AS MachineName ,
    CAST( SERVERPROPERTY( 'InstanceName' ) AS varchar( 30 ) ) AS Instance ,
    CAST( SERVERPROPERTY( 'ProductVersion' ) AS varchar( 30 ) ) AS ProductVersion ,
    CAST( SERVERPROPERTY( 'ProductLevel' ) AS varchar( 30 ) ) AS ProductLevel ,
    CAST( SERVERPROPERTY( 'Edition' ) AS varchar( 30 ) ) AS Edition ,
( CASE SERVERPROPERTY( 'EngineEdition')
WHEN 1 THEN 'Personal or Desktop'
WHEN 2 THEN 'Standard'
WHEN 3 THEN 'Enterprise'
END ) AS EngineType ,
CAST( SERVERPROPERTY( 'LicenseType' ) AS varchar( 30 ) ) AS LicenseType ,
     SERVERPROPERTY( 'NumLicenses' ) AS #Licenses;

Output

MachineName     Instance ProductVersion ProductLevel Edition          EngineType LicenseType #Licenses
--------------- -------- -------------- ------------ ---------------- ---------- ----------- ---------
VALHALLA-MDD06H EAP6     8.00.191       RTM          Standard Edition Standard   DISABLED    NULL

Click here to copy the following block

SELECT @@VERSION AS [SQL Server Details];

Output

SQL Server Details       
---------------------------------------------------------------------
Microsoft SQL Server  2000 - 8.00.191 (Intel X86) 
	Jul 27 2000 01:30:33 
	Copyright (c) 1988-2000 Microsoft Corporation
	Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 1)