sql express database

Hi,

I've created databases using sql 2000 etc, but how do you create databases and tables on sql express There is no Enterprise Manager or query analyser that I can see Do you have to create them through Visual Studio intead


Answer this question

sql express database

  • Erick Thompson - MSFT

    I think it's released and there is a separate download for SQL Management Studio.  Link should be somewhere in SQL Express download section. 

    Cheers,
    Kans

  • sdfeaf

    Glad it helped Jimmy_fingers.  Could you please mark this post as "Answered" (instructions below)   This helps other users that are searching know that this post provides an answer, and also allows those of us answering posts to target questions that are not answered.

    How do I indicate a post answered my question
    To mark your post as answered, click the Mark as Answer button to the right of the post.

    Thanks, MJ

  • markpre_ms

    As far as I know there is no Enterprise manager for SQL Express (as there was no for MSDE).
    You can manage the SQL2005 via command prompt, using the VisualStudio IDE or with the Microsoft SQL Server Management Studio Express . It is unclear to me if the Server Management has been released or if it is still in the Beta phase :-o

    Luca

  • Panason1

    Luca is correct.  Regarding Microsoft SQL Server Management Studio Express, it is currently available as a Community Technology Preview (CTP).  Final release should be available in Spring 2006.


  • Manuel Feller

    Many thanks for the help guys!!
  • sql express database