You can find out sql server details using below query that will help you to get the information about sql server which is installed on local machine.
SELECT SERVERPROPERTY(‘servername’) as [SQL Server Name],
SERVERPROPERTY (‘productlevel’) as [Service Pack],
left(@@version,48) AS [SQL Server Version],
SERVERPROPERTY (‘Collation’) as [Collation],
SERVERPROPERTY (‘LicenseType’) as [License Type] ,
CASE SERVERPROPERTY (‘IsSingleUser’)
WHEN 1 THEN ‘Yes’
WHEN 0 THEN ‘No’
ELSE
‘Null’ END as [Is Single User]