locked
Have I installed SQL Express or SQL 2008 R2? RRS feed

  • Question

  • I just installed VB and VCS Express 2010.  In the process, it installed a default instance of SQLEXPRESS 2008.  Great!

    Unfortunately, there are no "studio" tools to help build tables, views, etc.  The VB IDE provides limited ability to do these things.  Specifically, I have figured out tables and constraints.  However, I could not figure out how to build views, stored procedures, etc.

    On-line, there were several articles about installing the Management Studio to get these more capable tools.  So, I ran the setup again.  During the process, the License Agreement specifically cited SQL SERVER EXPRESS 2008, but other parts of the wizard acted like it was installing the full-up version.  How can I tell?

    I am specifically building to SQLEXPRESS for the time being.  I do not want to violate any licensing agreements.  So, how can I tell if the SQL EXPRESS installer is installing Express or 2008 R2?

    Thanks.

    Rob

    Friday, June 18, 2010 8:22 PM

Answers

All replies

  • With Visual Studio Express 2010 you have SQL Server 2008 SP1 Express and not R2

    Express edition of visual studio does not include management studio express just the database engine; you need to download and install it separately

    http://www.microsoft.com/downloads/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en 

    Friday, June 18, 2010 10:29 PM
  • I did download the Management Tools separately.  They installed.  The License Agreement for that product said SQL EXPRESS 2008, but everything else in the wizard suggested SQL SERVER 2008 R2.  My real question remains, did I inadvertently "upgrade" from SQL Express to SQL Server?

    Rob

    Saturday, June 19, 2010 3:29 PM
  • hi Rob,

    the installer package of "R2" version of SQL Server\SQLExpress 2008 clearly indicates the "R2" version... and installing the "basic" engine from VS2010 and the additional tool, SSMS, from the provided link provides you a "complete and usable" SQLExpress 2008 installation.. again, the R2 installer is "clear" about that and you can see it very clearly... you can stay with that, or, you can upgrade your scenario with SQLExpress 2008 R2 and related manament tool without breaking provided EULA.. the engine is free to download and use, as is the tool..

    you can download SQLExpress 2008 R2 installer package from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135 ... the "With Advanced Services" package includes both SQL Server Management Studio 2008 R2 and an additional engine, Reportin Services, you can (or not, depending on your choices) install on your machine, as long as the basic relational engine... with that installer package you can both install a fresh new instance or upgrade an existing one to 2008 R2 version.. for your convenience, you can perhaps have a look at experiences of mine to perform both tasks at http://www.asql.biz/en/Articles.aspx

    regards


    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools http://www.hotelsole.com/ - http://www.hotelsolericcione.de
    • Proposed as answer by Chirag Shah Saturday, June 19, 2010 6:09 PM
    Saturday, June 19, 2010 4:25 PM