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