SQL Server Error 2705

Richard J. Sears ( (no email) )
Wed, 26 Feb 1997 23:23:55 -0800

I have just installed Emerald 2.0.75 and replaced the Emerald Admin and
emerald.exe files with the 2.0.88.

I then copied fields.rpt and updttabs.sql to my root directory, ran the
admin, created the database and did a check db and got the Table errors
you (Dale) said to ignore.

However when doing a Update Database I get a string of errors like the
ones listed below:

SQL Server Error 2705 Column names in each table must be unique. Column
Name 'GroupID' in table AccountTypes is specified more than once.

Failed Query: ALTERTABLE AccountTypes ADD GroupID int REFERENCES Group
(GroupID) NULL DEFAULT NULL

This happens for each table (Discounts, Regions, InvoiceTypes,
ChargeTypes, etc).

Here is the system info:

NT 4.0
SQL 6.5
Emerald 2.0.88 (Admin shows 2.0.75)

Any help would be appreciated. Thanks

--------------------------------------------------------------------------------------------------
Richard J. Sears System Administrator

Web Communications Concepts, LLC rsears@webcc.net