Retrieving SQL Server Edition, Version and Service Pack Info

Submitted by Sergey on December 25, 2007 - 01:00

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
No votes yet