Directions for Creating the Greeting Card Pro SQL™   Database.

1.  The greetingcardproSQL database is emailed as a script file called greetingcardpro.sql.  Detach the file somewhere on your local computer.

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

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

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

5. Now execute the greetingcardpro.sql script to create the tables and queries in the database.  From the Tools menu of Enterprise Manager, select SQL Server Query Analyzer.

6. From within Query Analyzer, open the greetingcardpro.sql script file.   Select the greetingcardproSQL database from the DB: drop-down menu.

7. Execute the script by clicking the green Execute Query button.   If executed successfully, a message indicating 1 Rows Affected will appear.
   

8. Make some optimization settings to the database.  Right click on the greetingcardproSQL database from within Enterprise Manager.  Select properties.

9. Under the options tab, select "Select Into/bulk copy" as well as "Truncate Log on Checkpoint".  This will keep the log file from growing to a large size.