How to use SQL Server 2008?

Question

I am creating a client side application, and I usually use ms access for its database. But recently I am trying to use sql server 2008 and I was totally lost.

I have really no idea how to use SQL server 2008. Unlike MS Access, we can create a new database by just click on the new blank database button. But for SQL server, it looks like I need to connect to somewhere. Can someone explain to me how to create a new database in SQL server 2008?

Thanks :)

Answer 1

Try using the graphical management tool that comes with SQL server 2008



http://www.microsoft.com/express/Database/

Answer 2

Open SQL server Management Studio and connect. On the left hand side under object explorer you should see a 'databases' folder, right click that and select 'new database' from there its pretty self explanatory. or can use the following on an open query window (select 'new query') and type:



create database [enter_database_name]



then press f5 or click the execute button.

Answer 3

you need to basically deploy them on the same pc in case you truly ought to. Please be more suitable particular once you describe software. you're literally not attempting to position in sq. Server 2008 administration Studio(SSMS), you try to position in sq. Server 2008 administration Studio instruct (SSMSE). both way, both one among them are worthless until eventually you also deploy an version of sq. Server. Judging by utilising your unwillingness to pay for software, i'm assuming you'll opt for to position in sq. Server 2008 instruct version. So the question is, what OS are you operating 32 bit or sixty 4 bit? both way you need to position in the .information superhighway Framework 3.5 and its service %. a million. Did you reboot the computer?