The following will give you information about an Microsoft SQL Server instance which you may find helpful in determining the version, edition and number of cpu’s assigned to a SQL server.
In my case I am using Microsoft SQL Server 2014 Express but this will work on all versions of Microsoft SQL Server
SELECT @@VERSION AS 'SQL Server Version';
SELECT Serverproperty('Edition')
select scheduler_id, cpu_id, status, is_online
from sys.dm_os_schedulers
where status = 'VISIBLE ONLINE'
