Systems Management Question

Sql express vs full edition

03/25/2013 2446 views

I'm wondering if someone has come across a way to tell the difference between sql express 2008 and the full edition of microsoft sql 2008. Both have really similar build information and I'm looking for a way to generate a report showing which boxes have which version.

0 Comments   [ + ] Show comments


All Answers


query the following in the MSSQL db. This should show the relevant informations.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Answered 03/25/2013 by: Nico_K
Red Belt

  • better parseable may be this: Select @@version
    Unfortunately I don't have any of the versions handy here to check if there is a real difference. MS said both queries are different but I did not proved it
  • @@version is the best way

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ