/build/static/layout/Breadcrumb_cap_w.png

Sql express vs full edition

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.

Asked 11 years ago 2502 views
0 Comments   [ + ] Show comments

Answers (1)

Posted by: Nico_K 11 years ago
Red Belt
1

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

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Comments:
  • 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 - Nico_K 11 years ago
  • @@version is the best way - jdornan 11 years ago
 
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