SELECT SERVERPROPERTY('BUILDCLRVERSION') AS BUILDCLRVERSION
,SERVERPROPERTY('COLLATION') AS COLLATION
,SERVERPROPERTY('COLLATIONID') AS COLLATIONID
,SERVERPROPERTY('COMPARISONSTYLE') AS COMPARISONSTYLE
,SERVERPROPERTY('COMPUTERNAMEPHYSICALNETBIOS') AS COMPUTERNAMEPHYSICALNETBIOS
,SERVERPROPERTY('EDITION') AS EDITION
,SERVERPROPERTY('EDITIONID') AS EDITIONID
,SERVERPROPERTY('ENGINEEDITION') AS ENGINEEDITION
,SERVERPROPERTY('INSTANCENAME') AS INSTANCENAME
,SERVERPROPERTY('ISCLUSTERED') AS ISCLUSTERED
,SERVERPROPERTY('ISFULLTEXTINSTALLED') AS ISFULLTEXTINSTALLED
,SERVERPROPERTY('ISINTEGRATEDSECURITYONLY') AS ISINTEGRATEDSECURITYONLY
,SERVERPROPERTY('ISSINGLEUSER') AS ISSINGLEUSER
,SERVERPROPERTY('LCID') AS LCID
,SERVERPROPERTY('LICENSETYPE') AS LICENSETYPE
,SERVERPROPERTY('MACHINENAME') AS MACHINENAME
,SERVERPROPERTY('NUMLICENSES') AS NUMLICENSES
,SERVERPROPERTY('PROCESSID') AS PROCESSID
,SERVERPROPERTY('PRODUCTVERSION') AS PRODUCTVERSION
,SERVERPROPERTY('PRODUCTLEVEL') AS PRODUCTLEVEL
,SERVERPROPERTY('RESOURCELASTUPDATEDATETIME') AS RESOURCELASTUPDATEDATETIME
,SERVERPROPERTY('RESOURCEVERSION') AS RESOURCEVERSION
,SERVERPROPERTY('SERVERNAME') AS SERVERNAME
,SERVERPROPERTY('SQLCHARSET') AS SQLCHARSET
,SERVERPROPERTY('SQLCHARSETNAME') AS SQLCHARSETNAME
,SERVERPROPERTY('SQLSORTORDER') AS SQLSORTORDER
,SERVERPROPERTY('SQLSORTORDERNAME') AS SQLSORTORDERNAME
,@@VERSION AS VERSION
,SERVERPROPERTY('COLLATION') AS COLLATION
,SERVERPROPERTY('COLLATIONID') AS COLLATIONID
,SERVERPROPERTY('COMPARISONSTYLE') AS COMPARISONSTYLE
,SERVERPROPERTY('COMPUTERNAMEPHYSICALNETBIOS') AS COMPUTERNAMEPHYSICALNETBIOS
,SERVERPROPERTY('EDITION') AS EDITION
,SERVERPROPERTY('EDITIONID') AS EDITIONID
,SERVERPROPERTY('ENGINEEDITION') AS ENGINEEDITION
,SERVERPROPERTY('INSTANCENAME') AS INSTANCENAME
,SERVERPROPERTY('ISCLUSTERED') AS ISCLUSTERED
,SERVERPROPERTY('ISFULLTEXTINSTALLED') AS ISFULLTEXTINSTALLED
,SERVERPROPERTY('ISINTEGRATEDSECURITYONLY') AS ISINTEGRATEDSECURITYONLY
,SERVERPROPERTY('ISSINGLEUSER') AS ISSINGLEUSER
,SERVERPROPERTY('LCID') AS LCID
,SERVERPROPERTY('LICENSETYPE') AS LICENSETYPE
,SERVERPROPERTY('MACHINENAME') AS MACHINENAME
,SERVERPROPERTY('NUMLICENSES') AS NUMLICENSES
,SERVERPROPERTY('PROCESSID') AS PROCESSID
,SERVERPROPERTY('PRODUCTVERSION') AS PRODUCTVERSION
,SERVERPROPERTY('PRODUCTLEVEL') AS PRODUCTLEVEL
,SERVERPROPERTY('RESOURCELASTUPDATEDATETIME') AS RESOURCELASTUPDATEDATETIME
,SERVERPROPERTY('RESOURCEVERSION') AS RESOURCEVERSION
,SERVERPROPERTY('SERVERNAME') AS SERVERNAME
,SERVERPROPERTY('SQLCHARSET') AS SQLCHARSET
,SERVERPROPERTY('SQLCHARSETNAME') AS SQLCHARSETNAME
,SERVERPROPERTY('SQLSORTORDER') AS SQLSORTORDER
,SERVERPROPERTY('SQLSORTORDERNAME') AS SQLSORTORDERNAME
,@@VERSION AS VERSION