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'