Solved

where can I get the BookShopDB -easy

Posted on 2004-03-31
5
383 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 300 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

773 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