Determine SQL Server Version and SP level

posted on Thursday, January 04, 2007 10:25 AM by kfinley

I always forget this so just posting to remind myself later. :)

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Also the this command will get a the basics.

SELECT @@VERSION

Sources:
Q321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition
SQL Server Service Packs and Versions

Now Playing: Death Cab for Cutie - Transatlanticism - The New Year