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   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



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
Please log in to comment