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

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

Enter a database name of SyndicatePro or another appropriate name.

Click OK when finished and an empty is created.

Now execute the SyndicatePro.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 SyndicatePro .sql script file.   Select the SyndicatePro database from the DB: drop-down menu.

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.

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

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