chrismilnenaq
Technical User
Hello,
My company has been having problems with MS SQL 7. We are using W2K SP2 with SQL 7 SP3 on both machines. The problem is we dts a table to the backup server and after a few days of delete and insert statements the table becomes corrupt. We do a select into statement and try to create an index but the index says duplicate keys exist. The problem with that is the source database has primary keys on the first and second columns and so does the destination table. I try to run a series of statements to delete the duplicate rows and it does. But when trying to create an index again the same duplicate row error comes up again. The error is not on the same rows though. If I try to create an index it will give an error on say row 878 but the next time without deleting any duplicates it will give me an error on row 9323. I'm in a loop of deleting duplicates and trying to create the index. I've tried so many variations with obviously no success. I'd appreciate your help.
Thanks in advance.
Chris
chris@naq.com
My company has been having problems with MS SQL 7. We are using W2K SP2 with SQL 7 SP3 on both machines. The problem is we dts a table to the backup server and after a few days of delete and insert statements the table becomes corrupt. We do a select into statement and try to create an index but the index says duplicate keys exist. The problem with that is the source database has primary keys on the first and second columns and so does the destination table. I try to run a series of statements to delete the duplicate rows and it does. But when trying to create an index again the same duplicate row error comes up again. The error is not on the same rows though. If I try to create an index it will give an error on say row 878 but the next time without deleting any duplicates it will give me an error on row 9323. I'm in a loop of deleting duplicates and trying to create the index. I've tried so many variations with obviously no success. I'd appreciate your help.
Thanks in advance.
Chris
chris@naq.com
