Retrieving SQL Server Edition, Version and Service Pack Info | The Bereznikers

Retrieving SQL Server Edition, Version and Service Pack Info

By Sergey - Posted on December 25th, 2007

Tagged:

mssql
tsql

This is sample code. Add error handling and adjust to your requirements as necessary.

SELECT 
	SERVERPROPERTY('Edition') AS Edition,
	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel