Directions for Creating the ROI Wiz SQL   Database.
  1.  The ROIWiz database is emailed as a script file called ROIWiz.sql 

  2.  From within SQL Server Enterprise Manager, create a new database called ROIWiz .  Right-mouse click on databases, then select New Database.

  3. Enter a database name of ROIWiz or another appropriate name.

  4. Click OK when finished and an empty is created.

  5. Now execute the ROIWiz.sql (ROIWizEnterprise.sql for the Enterprise Edition) 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 ROIWiz.sql (ROIWizEnterprise.sql for the Enterprise Edition) script file.   Select the ROIWiz database from the DB: drop-down menu.  Be sure you have selected the correct database!

  6. Execute the script by clicking the green Execute Query button.   If executed successfully, a number of messages reading "(1 row(s) affected)" will appear.  You will also see Query Batch Completed at the bottom of the screen.

 

AdComplete.com, LLC    4536 Grove Park Dr.    Tallahassee Florida,  32311
Phone (407) 551-0777
Copyright (c) 2003-2006 AdComplete.com, LLC All Rights Reserved