AffiliateWiz database is emailed as a script file
Detach the file somewhere on your local
Launch SQL Server
Management Studio Express edition from your
Start--Programs--Microsoft SQL Server 2005 menu and
connect to the server.
Right-mouse click on
databases, then select New Database.
a database name of AffiliateWiz or another
OK when finished and an empty database is created.
One the left menu,
select the AffiliateWiz database and expand the
Now click the New
Query button on the toolbar menu.
From the File menu,
select Open File. Browse and find the
Toolbar, find the drop-down menu and make sure the
AffiliateWiz database is selected. This step is
very important or you will run the script on the
Now execute the sql
script by clicking the Execute button on the
The results pane at the
bottom should indicate that the Query executed
Be sure to create a maintenance plan that backs up your
database on a periodic basis. We highly recommend
daily backups as this will help keep the log file size