Directions for Creating the Link X Pro SQL™   Database

  1. The Link X Pro database is emailed as a script file called linkxpro.sql. Detach the file somewhere on your local computer.

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

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

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

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

  7. Execute the script by clicking the green Execute Query button.   If executed successfully, several messages will appear stating "(1 row(s) affected)"  You can now exit SQL Query Analyzer.

  8. Make some optimization settings to the database from within SQL Enterprise Manager.  Right click on the LinkXPro 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.