• By verasearch3, Wednesday, August 2, 2017 10:33:52 AM

  SELECT

  SERVERPROPERTY('ProductVersion') AS ProductVersion,

  SERVERPROPERTY('ProductLevel') AS ProductLevel,

  SERVERPROPERTY('Edition') AS Edition,

  SERVERPROPERTY('EngineEdition') AS EngineEdition,

  CONVERT(sysname, SERVERPROPERTY('servername')) AS ServerName

  select @@VERSION as FullName

  select cast(total_physical_memory_kb/1024000 as varchar) + 'GB' as Operating_System_RAM, (SELECT cpu_count FROM sys.dm_os_sys_info) as cpu_cores

  from sys.dm_os_sys_memory

There are no replies to this post.