-
The
AffiliateWiz database is emailed as a script file
called affiliatewiz.sql.
Detach the file somewhere on your local
computer.
-
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.
-
Enter
a database name of AffiliateWiz or another
appropriate name.
-
Click
OK when finished and an empty database is created.
-
One the left menu,
select the AffiliateWiz database and expand the
menu.
-
Now click the New
Query button on the toolbar menu.
-
From the File menu,
select Open File. Browse and find the
AffiliateWiz6.SQL file
-
On 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
wrong database.
-
Now execute the sql
script by clicking the Execute button on the
toolbar.
-
The results pane at the
bottom should indicate that the Query executed
successfully.
Note:
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
under control.
