CODEWITHSUNDEEP
sql-serverdatabasewindows
Rachel Richter
Rachel Richter

Reputation: 3

How do I create tables in Microsoft SQL Server 2008 R2 Express

I have installed Microsoft SQL Server 2008 Express R2 with tools. In windows start menu now I have an option for SQL Server Management Studio. So I click on that and a dialogue window pops up asking me to connect to a server. I don't know what server to enter into here and all I want to do is create a new database so I can store some simple information in tables. I did press cancel on the dialogue box and looked around in the management studio but I couldn't find a "create new table" option or anything particularly like that.

Upvotes: 0

Views: 2397

Answers (3)

Michael Riley - AKA Gunny
Michael Riley - AKA Gunny

Reputation: 5184

It's looking for <%ComputerName%>\SQLEXPRESS

If you don't know the name of your compter then...

Click Start
Right Click on My Computer
Click Properties
Click ComputerName tab

Upvotes: 1

sazh
sazh

Reputation: 1832

Use localhost as your server if you don't need to connect to an external server. Then in Object Explorer you'll be able to create new Databases and Tables within those databases

Upvotes: 0

MimiEAM
MimiEAM

Reputation: 2630

I haven't played around with the manager studio in a while, but I hope this helps http://msdn.microsoft.com/en-us/library/ms186312.aspx

Upvotes: 0

Related Questions