Find EDITION, VERSION and SERVICEPACK information of SQL Server

SQL, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Hello Friends

Generally, we choose the  @@VERSION to get the version information for SQL Server, but using this function we can’t get the Service Pack information installed…

Alternative way

Get Editions of SQL Server

SELECT SERVERPROPERTY(‘EDITION‘) AS EDITION

Get Version Detail of SQL Server

SELECT SERVERPROPERTY(‘PRODUCTVERSION‘) AS VERSION

Get the Service Pack installed on SQL Server

SELECT SERVERPROPERTY(‘PRODUCTLEVEL‘) AS SERVICEPACK

Related Posts

, , , ,