These instructions are for SQL Server 2000. 
If you are using SQL Server 2005 Express, please click here.
 

1.  The eNewsletterPro database is emailed as a script file called eNewsletterPro.sql (eNewsletterProEnterprise.sql for the Enterprise Edition).  

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

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

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

5. Now execute the eNewsletterPro.sql (eNewsletterProEnterprise.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 eNewsletterPro.sql (eNewsletterProEnterprise.sql for the Enterprise Edition) script file.   Select the eNewsletterPro 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.