SQL Server – How to find sql server version

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]

Leave a Reply

  

  

  


3 + 9 =