Need to create new database without using management studio

database sql-server-express sql-server-2008-express

You can use the SqlCmd utility from the command line to execute SQL.

Open a command prompt and then type SqlCmd.exe and press enter, you should then get 1) which means you are connected.

Once connected execute

1) CREATE DATABASE dbname2) GO

database sql-server-express sql-server-2008-express

Use CREATE DATABASE via sqlcmd or another other database connection (even VBA from Excel...)

database sql-server-express sql-server-2008-express

You could connect to it in code (.net express or something) with a connectionstring, then run an sql script to create a db (see http://msdn.microsoft.com/en-us/library/ms176061.aspx).

But why can't you use the management studio?

CodeHunter