Create a database in MS Sql Server

[drimades]

Hi!

I'm using Eclipse for the first time so I'm a newbie. If I have an instance of MS Sql Server running in my computer how can I create a new DB in Java from Eclipse. I've seen the syntax for connecting to an existing DB but don't know how to create one. Any idea?

 

[chrissie1]

YOu can always connect to the master database and then run a create database statement from there.

Christiaan Baes
Belgium

My Blog

 

[drimades]

Ok! What's the master database?

 

[chrissie1]

It's the database that is always there in sqlserver and that holds the system stored procedures and other things.

Christiaan Baes
Belgium

My Blog

 

[drimades]

Thanks!

 

[drimades]

Another question: what's the connection string for connecting to the master database of the Sql Server?

 

[chrissie1]

look at the site

http://www.connectionstrings.com/

Christiaan Baes
Belgium

My Blog

 

[AlexCuse]

And please, be very careful with the commands you send to the master database!

You can really hurt yourself in there.

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

[drimades]

Thank you! Sorry but still I can't find how to connect to the database. I'm posting some of the database properties taken from SQL Server Management Studio Express:
...
Database master
Spid 52

Server name ACER-1155CCFAC6/NetSDK
Instance name NETSDK
...
How is the connection string in this case?