Can't find Lesson01 PracticeSetup.sql file - exam 70-433

Question

The 'Microsoft SQL Server 2008 - Database Development' book includes sample databases and practice files.   For example,  the Lesson01 PracticeSetup.sql file creates a Sales database used in the excercises in chapter 2.   I can not find these files on either the companion CD nor in the various MS SQL Server directories on my hard disk.  This book is for exam 70-433.

If anyone has found these,  please point me in the right direction.   Thank you.

Answer 1

Found it.  The pratice files are copied to the 'USERS'  directory (folder) as opposed to the Practice folder as documented.

Answer 2

I am having the same problem but cannot find the missing file in the USERS folder.

Can anyone tell where I can find the relevant files?

Answer 3

I am having the same problem. Searched the PC, CD and no PracticeSetup.sql is to be found.
If anywone has this "USERS" folder and script please contact me. I would like a zip file if possible.
Thanks!

Answer 4

The example code files are on the companion CD.  In order to view these files you must go to the Code folder and run the executable file.  Once you have done that a new folder will be created here: C:\Documents and Settings\<USER>\My Documents\Microsoft Press\TK 70-433\Code

This folder contains all the example files for every chapter. 

Answer 5

Thanks Rose for the info! Documentation error from microsoft. Actually you can change that location where it installs by clicking in the change button and can give your own location.

Answer 6

i know there are files , but as book says PracticeSetup.sql file is still missing.

Answer 7

This file is installed when you install the code files from the CD that comes with the book.  It is installed in the following location:

C:\Users\<username>\Documents\Microsoft Press\TK 70-433\Code\Chapter02\Lesson 1

The file is called "Lesson01  PracticeSetup.sql"

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript