SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') The result will look something like below: 9.00.3054.00 SP2 Enterprise Edition