Quickly Get SQL Server Version, Edition and Update Level 2008-10-19 By Rob Symonds This query works on SQL Server 2000 and above: USE [master] SELECT CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - ' + CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' (' + CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'