Tuesday, June 9, 2009

2541: Using the labs outside of class

Please note: This is a workshop and is normally configured within a VPC environment. However, that having been said, you can install the entire course at home for practise by doing the following:
  1. Install Visual Studio 2005 (you can use the express version
  2. Install SQL Server (also express if you cannot get your hands onto STD or Enterprise)
  3. Make sure that you have installed the AdventureWorks database from the SQL Server installation disk. If you haven't got the sample database, then GOOGLE for "adventureworks.mdf download" and you will find ample support for downloading & installing the sample DB
  4. Using the DVD/CD that came with your training manual, run the LABFILES.EXE file - remembering where it installs all of the modules to.

Remember that each lab starts with a "Setup Procedure" that tries to create a couple of Stored Procs. Since they already exist from the first time you run them, the will give you errors that the Stored Procs already exist. Don't stress about this, just check that the other Stored Procs are created.

If you have any problems, please comment on them here and I will try to answer as soon as possible.

No comments:

Post a Comment