Wednesday, October 7, 2015

Sql Command to find product version and Edition

I was goggling for to find the current product version of Sql server several times in my environment .And I was the forget the query several times being human. So decided to save on web
SELECT
            SERVERPROPERTY('ProductVersion') AS ProductVersion,
            SERVERPROPERTY('ProductLevel') AS ProductLevel,
            SERVERPROPERTY('Edition') AS Edition,
            SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime',
            SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion' 

GO