When upgraded from Wise Package Studio 7 SP1 to Wise Package Studio 7 SP2, everything updates properly with the exception of the Workbench database. The Workbench database in Wise Repository Manager shows that it failed to update.
Below is the error output from SQL Analyzer:
Server: Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'ProjectDirEx' in
table 'Projects' is specified more than once.
Server: Msg 1779, Level 16, State 1, Line 2
Table 'Tasks' already has a primary key defined on it.
Server: Msg 1750, Level 16, State 1, Line 2
Could not create constraint. See previous errors.
There are two ways to correct the problem:
Windows 2003 Server*