[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

where can I get the BookShopDB -easy

Posted on 2004-03-31
5
Medium Priority
?
392 Views
Last Modified: 2008-03-10
Where can I get the BookShopDB.

I'm trying to do the exercises in the SQL Server 2000 database design and Implimentation, but I can't find the BookShopDB it always refers to.

-broke
0
Comment
Question by:brokeMyLegBiking
  • 2
  • 2
5 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 10725621
its not the pubs database is it?

what does 'SQL Server 2000 database design and Implimentation' this  actually refer to?
0
 
LVL 34

Accepted Solution

by:
arbert earned 1200 total points
ID: 10725745
Are you using some of the MCDBA training materials?  The first part of the materials have you create the database before you use it....
0
 
LVL 4

Author Comment

by:brokeMyLegBiking
ID: 10726326
I'm pretty sure that the BookShopDB is a deparate database from the Pubs database, because the book refers to them both separately.

I am working on exam 70-229, an elective for my MCSD certification. This is the first course in my certification that I've taken.

Where can I get the first part of the MCDBA training materials?
0
 
LVL 34

Expert Comment

by:arbert
ID: 10727227
Ya, BookShopDB is part of the training materials--I would suggest you get it from the source you got your other materials from...
0
 
LVL 4

Author Comment

by:brokeMyLegBiking
ID: 10727782
ok, I guess they were included all along .. you just have to create everything from scratch. All they include is sample data, I had to create relationships and tables. Tough stuff for a guy as lazy as I am!

I skipped chapter 3 & 4 trying to get to the good stuff, but just went back and just built the database.

thx

-broke

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question