SQL Server Edition-Product Level-ProductVersion SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')
SELECT @@ServerName ServerName,SUBSTRING(CONVERT(varchar(255),@@version),0,charindex(‘(‘,CONVERT(varchar(255),@@version))) Sqlversion, SERVERPROPERTY(‘productversion’) prodcutversion, SERVERPROPERTY(‘productlevel’) productlevel, SERVERPROPERTY(‘edition’) Reply
SELECT @@ServerName ServerName,SUBSTRING(CONVERT(varchar(255),@@version),0,charindex(‘(‘,CONVERT(varchar(255),@@version))) Sqlversion,
SERVERPROPERTY(‘productversion’) prodcutversion, SERVERPROPERTY(‘productlevel’) productlevel, SERVERPROPERTY(‘edition’)