entity table - where to do that?

Question

entity table - where to do that?

nemonadia

Grasshopper

Points: 12
More actions
May 9, 2005 at 2:26 am

#88869

Hi,
i have never used SQL server 2000 before, but i am not new to the knowledge of database design and stuff like that.
I installed SQL server 2000 develper edition on my WIn XP Professional Edition.
Now i want to create a table for me to fill up the field name, data type, etc.
Where do i do that?
In my Start>AllPrograms, I have two choices: Microsoft SQL server and Microsoft server switch.
Which program inside Microsoft SQL server do i choose to ativate the SQL? I have tried everything but i cannot seem to get what i want.
Please advise.
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Welcome to the family!

Within your Microsoft SQL Server program group you'll find Books Online BOL). Unlike other MS product documentation, SQL Server's online manual is exceptionell and always the first place to look for information.

You'll also note two other items: Enterprise Manager (EM) and Query Analyzer (QA). EM is a GUI tool to administrate your server.

Use QA to create database objects, queries and this whole stuff. When QA starts, you'll be asked for the server to connect. Either type here the workstation or simply a . to connect to the local server. Next, make sure you're in the appropriate data for your statements. That is the combo box in the tool bar. If you've installed the sample databases PUBS and NORTHWIND, I would start playing around with these.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

nemonadia Grasshopper Points: 12 More actions · Answer 2

Ok i understand what you mean by going to the Query Analyser

but in the SQL server to log into, there are no active servers to choose from.

What is going on? Have I missed out something when I install the SL server 2000?

bledu SSChampion Points: 12335 More actions · Answer 3

on the SQL Server name dropdown put the a dot(.) or 127.0.0.1 if the server is sitting on your machine or put the name of your machine

choose SQL authentication. put the sa username and password.

Everything you can imagine is real.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Alternatively click on the button next to the combobox. You should see a windows popping up showing all available active servers. Once you've connected, QA "remembers" your last servers.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

bledu SSChampion Points: 12335 More actions · Answer 5

I suggest a good book on sql server 2000, it will help you a great deal.

Everything you can imagine is real.

Mike Prascak SSC Eights! Points: 930 More actions · Answer 6

Use Enterprise Manager to create new databases and tables. Try right clicking on everything to bring up the common tasks. Create a Server Group first, then a new SQL Server Registration, then your tables.

Mike