Presumably, the "ProjectTimeTracker SQL Server Script.sql" (part of the downloadable zip file for this book) can be used to create the physical Project Time Tracker database.

How does one invoke this script?

Thanks in advance!

saxomopho

There are two ways to do this. You DO need to have the Microsoft SQL Server Management Studio software installed. If you don't, you can go back to your SQL Server install and add it.

Open the Mgt Studio. Go to the Databases node on the tree and double click. You should see existing databases on the right pane. Right-click the database node and select "New Database". Give it the name ProjectTimeTracker and save it.

Now, double-click the ProjectTimeTracker database icon on the explorer tree. This makes it the active database.

Now, you can run the script in one of the two ways described here: 1)Navigate from the File/Open/File menu to the script in the Wrox download file directory structure on your list. It will open in the right pane. At this point, just click the !Execute button on the tool bar. Or 2) Open the script that you downloaded from Wrox in a text editor. Copy the contents to your clipboard. In the SQL Management Studio, with the ProjectTimeTracker database having been double-clicked, click the "New Query" button on the tool bar. Past the contents of your clipboard into the empty right pane and click the !Execute button.

After executing the script, you need to right-click the ProjectTimeTracker database and select "Refresh" before you will be able to see your tables and columns.

Hope that helps. I just had to figure it out myself, too.

Paul

Regards,
Paul

<><><><><><>&l t;><><><><><>< ><><><><><><&g t;<>
Source Imaging, LLC.
Paul Engel, President
Certified Document Imaging Architech (CDIA)
Summation Certified Trainer (SCT)
inData Certified Trainer
mailto:[email protected]
Voice: 859-255-5222
Fax: 859-514-1705
www.source-imaging.com
<><><><><><>&l t;><><><><><>< ><><><><><><&g t;<>