Load Instructions:

Pre-requisites

SQL 2005 Standard or above 

Visual Studio 2005 Standard or above 

1> Start SQL Management Studio

2> Connect with an appropriate account (what creds?)

3> Open "Script04 Security.sql" in your favourite text editor and change the machine name from 'MARCPE01' to your machine name

4> Save the updated file

5> Open "Script02 Proc.sql", find the location where the assembly "SqlPasswordProcs" is loaded into the database and change the file path to reflect where you have this assembly (should be in the same folder that you found this text file).

6> Save the updated file

7> Load and execute the scripts in this order

"Script00 CreateDB.sql"
"Script01 Tables.sql"
"Script02 Procs.sql"
"Script03 Data.sql"
"Script04 Security.sql"

NOTE: there is no need to run the "Script05 Gen Data.SQL". This code is used to generate "Script03 Data.SQL"