03/25/2013 2378 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