However, instead of playing around with the Northwind or pubs databases, let’s create our own.
Right click on the databases node in the left pane and choose the New Database option.
Once you’ve found it, right click on it and choose the Open Table - Return all rows option.
We’ll 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.
When it loads, you’ll notice two panels: the first is a tree view and the second is a list of items contained within the selected node of that tree.
Expand the "Microsoft SQL Servers" branch in the left panel and also expand the "SQL Server Group" branch.
Back in 1995 when the majority of Websites were still serving static content (i.e. 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 My SQL are free), some are supported cross-platform, and others are supported with native providers or pure source code libraries.
plain HTML files), database driven sites were nowhere near as popular as they are today. In this article we’re going to take a beginner’s look at Microsoft SQL Server 2000.
Throughout this article we will accomplish many things firstly with Enterprise Manager, and then with plain TSQL code in Query Analyzer.
Now that we’ve got a bit of jargon out of the way, let’s create our first database.
Expand this node and you’ll see a number of folders appear in the right pane: databases, data transformation services, management, replication, security, support services and meta data services.