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
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.
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 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.
sql express database
Erick Thompson - MSFT
Cheers,
Kans
sdfeaf
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
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
Manuel Feller