Hi all,

I came across this database this morning. It belongs to a client of ours who
was reporting some errors when using our software. On inspection of the
database the table in question seems to have duplicates in the primary key
column.

Has anyone ever seen this before, or do they know of how it could occur? The
table does not have any foreign keys and the database is generally only
accessed by the one connection.

I have made a copy of the database available, however all of the triggers /
stored procedures / views and non-related tables have been removed. The only
table in the database is titled MBUSERCOMPANY, if you look at the row where
COMPANYNAME is 'Seaside Home Loans' you will see that there are two entries
both with the same key.

The database zipped down to ~3Mb, I tried doing a backup/restore on it but
the restore failed with an integrity check error (the duplicate PK).

Here's the database:
http://www.transactive.com.au/dup_pk.zip

Any insight into this would be great.

Cheers,

Ryan Thomas
TransActive Systems

P: (02) 4322 3302
F: (02) 4325 1141
E: ryan@...
W: http://www.transactive.com.au/



[Non-text portions of this message have been removed]