Need to create new database without using management studio

database sql-server-express sql-server-2008-express
remo picture remo · Jul 9, 2010 · Viewed 53.8k times · Source

How to create new database with SQL Server Express 2008 without using Management Studio?

Do i need to download sp1?

Answer

Chris Diver picture Chris Diver · Jul 9, 2010

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 dbname
2) GO

Related questions

How can I do a BEFORE UPDATED trigger with sql server?

I'm using Sqlserver express and I can't do before updated trigger. There's a other way to do that?

Read More
Making a DateTime field in a database automatic?

I'm putting together a simple test database to learn MVC with. I want to add a DateTime field to show when the record was CREATED. ID = int Name = Char DateCreated = (dateTime, DateTime2..?) I have a feeling that this type of …

Read More
Windows could not start the SQL Server (SQLEXPRESS) service on local computer. Error 1053

I am running Windows 7 32 bit and I have IIS, Visual Studio 2008, 2010 installed. I am haunted by this error in SQL Server 2008 which is: Windows could not start the SQL Server (SQLEXPRESS) service on local computer. Error 1053: The service did not …

Read More