I am developing in visual studio 2008 (new) and it would be convenient to to have an Enterprise Manager / SQL Server Development Studio like tool to manage the databases. I am wonder what other developers who don't have acccess to SSDS are using.
                +2 
                A: 
                
                
              Microsoft SQL Server Management Studio Express
Documentation is here.
                  Mitch Wheat
                   2009-05-16 16:52:21
                
              This is both correct and actually quite amusing.
                  IainMH
                   2009-05-16 16:53:45
                @IainMH: why is that?
                  Mitch Wheat
                   2009-05-16 16:54:44
                
                
                A: 
                
                
              
            There is a Management Studio Express available at: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
Does most things the full version does. But you can get a cheaper version of SQL Server for Development with the full kit I believe. I got one for 2000, cost me £30.
                  Program.X
                   2009-05-16 16:52:42