title: SQL Server 2008 installed but missing sqlbrowser.exe and management studio?
body: <p>I wanted to know how to detect which edition of SQL Server 2008 is installed on my PC. The answer to that question involves using sqlbrowser.exe but it seems I don't have that file in its default location. I also don't seem to have the SQL Server Management Studio.</p>
  
  <p>I'm using Windows 7 and Visual Studio 2010... does an edition (perhaps "express") of SQL Server come with either of those? which edition would that be? Should I uninstall it and reinstall a full version or can I get sqlbrowser.exe and the management studio separately and add them on?</p>
  
  <p>I know this is going to take some time, so I'd prefer to canvass people's views beforehand.</p>
  
  <p>Thanks in advance for your help on this supposedly simple yet typically frustrating task.</p>