I recently downloaded SQL Server 2005 Express Edition while downloading
Visual Web Developer 2005 Express. The installation went of smoothly
but strangely, unlike SQL Server 7 & SQL Server 2000, I don't find any
UI like "Enterprise Manager" where one can create new databases,
tables, stored procedures, triggers etc. There's the "Configuration
Manager" (whose icon resembles the "Enterprise Manager" icon in SQL
Server 7 & SQL Server 2000) but there's no provision for creating &
maintaining databases, tables etc...I don't find the Query Analyzer as
well. I even searched the "Help" topic but couldn't locate anything
worthwhile.

Now how do I create new databases, tables, stored procedures etc. in
the SQL Server 2005 Express Edition (like how the different database
objects are created in SQL Server 7 & 2K)?

Please note that prior to installing SQL Server 2005 Express Edition, I
was using SQL Server 7. I uninstalled it (though the MSSQL7 directory
still exists in my C:\ drive) & then installed SQL Server 2005.

Thanks,

Arpan

[quoted text, click to view]
<snip>

You need SQL Server Management Studio Express. Go to step 3 here
http://msdn.microsoft.com/vstudio/express/sql/download/.