Home arrow SQL Server arrow Building Your First SQL Server 2000 Database

Building Your First SQL Server 2000 Database

SQL Server 2000 is one of the most popular RDBMS's for the Windows platform. Never worked with SQL Server 2000 before but dying to know how? In this article Mitchell looks at how to create your first database, and also shows you how to manipulate this database through both Enterprise Manager and Query Analyzer.

Author Info:
By: Mitchell Harper
Rating: 5 stars5 stars5 stars5 stars5 stars / 86
April 02, 2002
  1. · Building Your First SQL Server 2000 Database
  2. · Creating a database with Enterprise Manager
  3. · Creating a database with Query Analyzer
  4. · Manipulating our database
  5. · Conclusion

print this article

Building Your First SQL Server 2000 Database
(Page 1 of 5 )

Try surfing around the Internet and finding me a popular site that isn't using some sort of database to store its content. I bet you'll have a tough time trying to find just one popular site (i.e. a site with over 5,000 unique visitors a day) that doesn't use some sort of DBMS, such as SQL Server 2000, MySQL, or Oracle.

As I'm sure you're aware, it's extremely difficult to build a dynamic web site without a way to access and manipulate your content dynamically. Back in 1995 when the majority of web sites were still serving static content (i.e. plain HTML files), database driven sites were nowhere near as popular as they are today. Why do you think this is? Are databases easier to setup today? Is web server software more user friendly? Or was it just a natural progression that we as web developers went through to "evolve" from the way we developed "back then"?

I would like to think it's all of these things. Today we have databases such as MySQL and SQL Server that can be setup on a development machine with very little expertise: you simply run the setup program, change a couple of options and you're up and running in 20 minutes or so. It also seems that databases are "the way to go" these days, which makes sense when you think about it: they're readily available (some such as MySQL are free), some are supported cross platform, and others are supported with native providers or pure source code libraries.

In this article we're going to take a beginners look at Microsoft SQL Server 2000. We will look at how to create our first database, and also how to manipulate this database through both Enterprise Manager and Query Analyzer. If you've never worked with SQL Server 2000 before but have always been curious, then this article's guaranteed to get you up and running in no time.

Before we proceed however, you should have SQL Server 2000 installed on your machine. I'm running Windows 2000 Advanced Server, but SQL Server 2000 can also be installed on Windows 2000 Server, Windows 2000 Datacenter Server, and Windows NT 4.0 with service pack 5. If you'd just like to fiddle around with SQL Server 2000 for the span of this article, then you'll be glad to know that you can download a free 120-day trial version of it by clicking here.

If you have any trouble with your installation then check MSDN or consult the reference material that was included with your copy of SQL Server 2000.
blog comments powered by Disqus

- Executing SQL Server Stored Procedure from P...
- How to Search for Date and Time Values Using...
- Replication: SQL Server 2000 - Part 2
- Replication: SQL Server 2000 - Part 1
- SQL Sever: Storing Code in Binary or Text Fi...
- Execute SQL on Multiple Tables/Columns - New...
- How to Connect to a SQL Server from Visual F...
- SQL Server Hardware Tuning and Performance M...
- Primary Key on Multiple Tables New RDBMS C...
- Migrating from Sybase to SQL Server
- What's Best for DBAs? GUI or T-SQL Comma...
- How to Perform a SQL Server Performance Audit
- An Introduction To The Bulk Copy Utility
- SQL Server Stored Procedures 101
- Building Your First SQL Server 2000 Database

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials