Creating the eNewsletter Pro SQL
These instructions are for SQL
If you are using SQL Server 2005 Express, please
eNewsletterPro database is emailed as a script
file called eNewsletterPro.sql (eNewsletterProEnterprise.sql
for the Enterprise Edition).
within SQL Server Enterprise Manager, create a
new database called eNewsletterPro .
Right-mouse click on databases, then
select New Database.
a database name of eNewsletterPro or another
OK when finished and an empty is created.
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.
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!
the script by clicking the green
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.