Working With SQL Server Developer Edition [closed]

Question

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question so it's on-topic for Stack Overflow. Closed 6 years ago. Improve this question I just bought Visual Studio 2008 Professional and it came with SQL Server 2005 Developer Edition. I'm used to using SQL Server 2005 at work, but the Developer edition doesn't seem to come with Server Management Studio, so I'm at a bit of a loss. A few questions: What resources are there for configuring and setting up SQL Server 2005 Developer Edition? What are some resources for managing databases (I know that I can have Multiple Databases with SQL Server 2005), and what 'extras' are provided by Developer Edition? Are there any funky things I need to know about if I were to create a database and move it from Developer Edition to an actual deployment server? Are there any other 'gotchas'? Edit: I've answered the 'Why isn't SQL Server Management Studio showing up' question below. Resources for the other questions are still appreciated. Any other insights? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

OK, If you actually have the full Developer edition on SQL2005 it does have SSMS with it, you just didnt choose that option in the install. What is more likely is that you installed SQL 2005 Express Edition which does not include SSMS (SSMS = SQL Server Management Studio) To manage your SQL instance you should download SQL Server Management Studio Express from here http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en keep in mind that Express installs with an instance name so your server will actually be MACHINENAME\SqlExpress by default. And SQLExpress databases are exactly the same as regular SQL Server - the db engine just has limitations when you are running Express. Good luck.