creating a database

OK,

I have downloaded and installed 2005 express. All I want to do now is create a new database. I do not see where to do that. All that was installed was the SQL Server Configuration Manager and the Surface Area configuration. Am I missing something. I guess I am looking for something similar to Enterprise Manager. Where is it



Answer this question

creating a database

  • Matt Beckman

    Newbie here...

    I installed the SQL Server from the VWD. I would like to get the SSMSE, do I need to uninstall everything (i.e. VWD, SQL Server) before downloading SSMSE

    The other scenario:

    What if I would like the Advanced Services instead, do I need to uninstall everything before downloading


  • Chris Woods

    You should be able to install SSMSE on top of your current installation without uninstalling SQL Express.

    wrt Advanced Services, you should be able to install it to a different instance. Haven't tried though.

    Cheers.



  • Jubin

    Yep, what you need is SQL Server Management Studio Express which is a version of SQL Server Management Studio specially tailored for SQL Server Express.

    you can download it from http://msdn.microsoft.com/vstudio/express/sql/download/



  • creating a database