|
|
Directions for Creating the Affiliate Wiz SQL Database (SQL
2000 Instructions)
SQL 2005 Users, Click Here |
-
The
AffiliateWiz database is emailed as a script file
called affiliatewiz.sql.
Detach the file somewhere on your local
computer.
-
From
within SQL Server Enterprise Manager, create a new
database called AffiliateWiz.
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 is created.
-
Now
execute the affiliatewiz.sql script to create the
tables and queries in the database.
From the Tools menu of Enterprise Manager,
select SQL Server Query Analyzer.
-
From
within Query Analyzer, open the affiliatewiz.sql
script file. Select
the AffiliateWiz database from the DB: drop-down
menu.
-
Execute
the script by clicking the green
Execute Query
button. If
executed successfully, a message indicating 1 Rows
Affected will appear.
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.
|
|
