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?

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/

|||

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?

|||

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.