SELECT CONVERT(varchar, serverproperty('ServerName')) AS ServerName,
CONVERT(varchar, serverproperty('productversion')) AS productversion,
CONVERT(varchar, serverproperty('productlevel')) AS productlevel, CONVERT(varchar,
serverproperty('edition')) AS edition