SQL Server Edition-Product Level-ProductVersion

 

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')

 

image

One thought on “SQL Server Edition-Product Level-ProductVersion”

  1. SELECT @@ServerName ServerName,SUBSTRING(CONVERT(varchar(255),@@version),0,charindex(‘(‘,CONVERT(varchar(255),@@version))) Sqlversion,
    SERVERPROPERTY(‘productversion’) prodcutversion, SERVERPROPERTY(‘productlevel’) productlevel, SERVERPROPERTY(‘edition’)

    Reply

Leave a Reply

Your email address will not be published.