Article: KB-SQLPK

SQL Script: WordTricks 9.0.0 Create Primary Keys SQL.txt

Correction to WordTricks Database Structure

The WordTricks data structure uses unique ID numbers in many of the tables. In the MS Access environment, the columns for these unique ID's are designated as "Primary Keys" so that there is no chance that records can be duplicated.

However, due to an oversight, the WordTricks data structure in SQL Server environments was created with no such "Primary Key" designations.

This is unlikely to cause immediate problems, but should be corrected.

What Should I Do?

If your installation is on a Microsoft SQL Server or MSDE and you are familiar with SQL Enterprise Manager, you should follow these steps.

1. Download the Update SQL script. (WordTricks 9.0.0 Create Primary Keys SQL.txt)
2. Launch SQL Enterprise Manager or Query Analyser
3. Attach to your SQL Server and open the WordTricks database.
4. Copy and Paste the contents of the Update SQL Script into an SQL window.
5. Execute the Script.

If you are unfamiliar with SQL and/or uncomfortable with this process, WordTricks support staff will be glad to assist you or complete the task via remote access.