This newbie is still confused!

[Stevehewitt]

Hey ppl,

I know your all gonna get annoyed with me but I still have a problem. I just don't know the very starting blocks of SQL Server. I have read the fantastic FAQ on tutorials but I just need the first step. I have installed MS SQL Server 2000 on my Win2k Server box, but I don't know what to do next. After planning on paper, what is the very first thing I do to create a SQL backend database?!? I am using Access 2K to create/manage/run it but I just need to realise HOW to start the bloody thing off using SQL!

Cheers ppl, I know its not easy answering newbie questions!

Many thanks in advance. Steve Hewitt
Systems Manager

Windows 2000 Microsoft Certified Professional (75 - 215)

http://welcome.to/stevehewitt

 

[VogonPoet]

Are you proficient with Access?

Michael

 

[whool]

Easiest way to start is by opening Enterprise Manager. Once you have registered the the server in a Server Group you can easily create a new DB by going to the Databases branch on the tree and right clicking. Once done you can right click on the Database you've created to add tables etc. Its fairly intuitive. You can also create a diagram for your DB (Diagrams branch of Database) and use it to build the objects, similar to how its done in access. (Ulimately it will become easier to build your DB with SQL scripts using Query Analyser but Enterprise Manager GUI is easier to begin with)

Does this help?

Yael

 

[Guest_imported]

Hey,

Thanks for the responses. I know a fair bit about access but if I try a new project it saids that it can't contact the SQL Server. Some ODBC error.

Any ideas? P.S. What was that Enterprise Manager, and how do I access it?

 

[Guest_imported]

The reason I asked the question is I had never worked in SQL until about a year ago. Prior to that I had done a lot of work in Access.

SQL should have created a program group on your computer. There are three program you will need frequently: Enterprise Manager, Query Analyzer and Books on Line.

I would suggest starting with books on line. As Whool suggested, you need to register the server and create a database. I think the BOL can walk you through both of these.

Also, there are a number of good books out there if you are new to SQL server. I found several of them very helpful.

Michael

 

[Stevehewitt]

Thanks again ppl. I have just realised that the bloody installation messed up and only half of it is on.

Thanks again! Steve Hewitt
Systems Manager

Windows 2000 Microsoft Certified Professional (75 - 215)

http://welcome.to/stevehewitt