My first Server + SQL Server 2005 set up

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

My first Server + SQL Server 2005 set up

Author

Topic

winterh
Posting Yak Master

127 Posts

Posted - 2009-10-08 : 15:27:21

Hi. Just installed Windows 2003 to an old desktop I have.

WOuld anyone walk me through configuring this properly and installing SQL Server 2005 and setting up my very own first database?

YOu can take me on as a little project xD

p.s Madhivanan, I know you want to help :P

Cheers big boys.

[ /fail at query]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-10-09 : 08:28:54

Did you find any difficulties when trying to install SQL Server 2005?

Madhivanan

Failing to plan is Planning to fail

winterh
Posting Yak Master

127 Posts

Posted - 2009-10-09 : 08:37:46

Yar I did, so i bought SQL Server 2000 instead, which installed nicely. I figured I will just use SQL Server 2000 until I am confident using it, then upgrade to 2005, then to 2008 I have all the software and keys I need lol, spent lots of £££ buying them.

I am having trouble setting up my first DB. I can create it and add tables and rows, but when I use query analyser I don't think it knows which database to query! How do I tell it which database I am querying?

Also, how do I input data without using that stupid thing where i just type what I want directly into the tables like a noob. I would rather use SQL to populate the tables, but I don't know where i write the SQL statement (Which module of SQL server 2000 do I use?)

xD

[ /fail at query]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-10-09 : 08:48:44

If you have installed SQL Server 2000, you can use Query Analyser to execute the queries
To point to the database you want, execute this

Use your_db

--rest are your codes

Madhivanan

Failing to plan is Planning to fail

winterh
Posting Yak Master

127 Posts

Posted - 2009-10-09 : 08:53:30

Is it really that simple? man I am newb. Cheers Madhivanan.

Could you simply explain how to set up foreign keys? I am new to the set up of a DB, noly been using SQl for 2 monthes. And I only write reports querying existing data, never set one up before :)

[ /fail at query]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-10-09 : 09:40:54

Read about FOREIGN KEY constraints in SQL Server help file. It has an example code

Madhivanan

Failing to plan is Planning to fail

winterh
Posting Yak Master

127 Posts

Posted - 2009-10-09 : 09:46:28

Cheers Mad. Will look it up when I get home. Remember if I ask more newb questions that this is my first server and Db EVER! Your the man Madhivanan

[ /fail at query]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-10-09 : 09:47:47

quote:
Originally posted by winterh

Cheers Mad. Will look it up when I get home. Remember if I ask more newb questions that this is my first server and Db EVER! Your the man Madhivanan

[ /fail at query]

You are welcome. Ask here if have any problems in writing the queries

Madhivanan

Failing to plan is Planning to fail

winterh
Posting Yak Master

127 Posts

Posted - 2009-10-09 : 09:49:52

Will do. :-)

[ /fail at query]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources