View Single Post

   
  #3 (permalink)  
Old 03-04-2008, 07:23 AM
Erland Sommarskog
 
Posts: n/a
Default Re: Getting started with SQL Server Express Edition - total newbie

Robert (cpq1bcle[REMOVE]@verizon.net) writes:
> I installed SQL Server Express Edition on my computer but I can't
> figure out how to get into the Enterprise Manager to create a database.
> When in click on SQL Server in programs I get Configuration Tools. When
> I click on Configuration Tools I get SQL Server Configuration Manager,
> SQL Server Error and Usage Reporting, and SQL Server Surface Area
> Configuration. That's all. How to go to the screen to create a
> database?


The plain download of SQL Express comes only with the command-line tools
SQLCMD and OSQL. Which certainly are sufficient to create databases, but
not very fun to work with in the long run.

So you certainly want SQL Server Management Studio Express, which is
available for free from
http://www.microsoft.com/downloads/d...displaylang=en


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Reply With Quote