SQL Express 2012 SSMS and Profiler

• Neil Shilladay-465156

  SSC Enthusiast

  Points: 172

  More actions

  January 15, 2014 at 2:35 pm

  #281246

  I downloaded SQL Express with tools, under the assumption that 2012 Express comes with the full features of SMSS.

  I installed as a named instance (I already have 2008 R2 Express). When I open SMSS, I can see it has updated to 2012, but Profiler and DTA are not listed under Tools.

  Should I have installed Advanced Services edition to gain these tools, or is there some arcane ritual I need to perform to enable them ?

  Thanks

  Neil

• Sreekanth B

  SSCertifiable

  Points: 6145

  More actions

  January 15, 2014 at 2:51 pm

  #1680456

  Profiler and DTA are not included in any of the 3 Express Edition flavors...(Express, Express with Tools, Express with advanced Services)

  FYI

  http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx

• Neil Shilladay-465156

  SSC Enthusiast

  Points: 172

  More actions

  January 15, 2014 at 2:56 pm

  #1680459

  Thanks Sreekanth. Thought it was too good to be true !