SQL version and service pack level

,

Run the above query to obtain both the server version and SP level of your SQL server.

SELECT 	@@servername 'Server Name',
	substring(@@version,1,charindex('-',@@version)-1)
	+convert(varchar(100),SERVERPROPERTY('edition'))+ ' '+
	+convert(varchar(100),SERVERPROPERTY('productlevel'))'Server Version'

Rate

2.7 (10)

Share

Share

Rate

2.7 (10)